FAQ

PostgreSQL > pgsql-hackers > February 1997

Search Discussions

114 discussions - 297 posts

  • Are non-gcc C compilers going to understand the 'extern "C"' construct? ------------------------------
    Bruce MomjianBruce Momjian
    Feb 8, 1997 at 8:21 pm
    Feb 19, 1997 at 8:12 pm
  • ^^^^^^^^ You should use bpchar_ops ! vac= create unique index test_idx on test using btree (call_id bpchar_ops); CREATE vac= vacuum test; VACUUM vac= insert into test values ...
    Vadim B. MikheevVadim B. Mikheev
    Feb 8, 1997 at 9:52 am
    Feb 10, 1997 at 4:41 am
  • What's the deal with the "ANSI compatible" 'date' type? I'm reading the grammar from Microsoft's ODBC reference, which is "taken directly from the X/Open and SQL Access Group SQL CAE specification ...
    Dan McGuirkDan McGuirk
    Feb 26, 1997 at 1:50 am
    Feb 27, 1997 at 4:51 pm
  • Hi there. I first found this problem in version 1.08; now I have tried it again with the just-released 6.0, and it still works. It's very simple; just telnet to the postgres port, and frighten the ...
    Alvaro Martinez EchevarriaAlvaro Martinez Echevarria
    Feb 4, 1997 at 7:56 pm
    Feb 13, 1997 at 8:06 am
  • Is there a reason for the -e flag on the postmaster, and not just a -e on postgres? If not, it should be removed. All postgres-specific options are passed via the -o flag. ...
    Bruce MomjianBruce Momjian
    Feb 18, 1997 at 4:47 am
    Feb 19, 1997 at 5:37 am
  • - ---------- Forwarded message ---------- Date: Sun, 16 Feb 1997 14:31:25 +0000 From: jburnes <jburnes@diac.com To: mcguirk@indirect.com Subject: a fix for postgresql Dan: I just though I would get a ...
    Dan McGuirkDan McGuirk
    Feb 17, 1997 at 1:23 am
    Feb 17, 1997 at 1:54 pm
  • At this point, I think we can conclude 6.0 was a big success, and there were no major "show-stopper" bugs. We planned a 6.1 release at the end of this month. However, my mailbox is full of complex ...
    Bruce MomjianBruce Momjian
    Feb 10, 1997 at 2:03 am
    Feb 10, 1997 at 9:24 am
  • With all the talk of data types, input/output formats, and other such things, I think now would be a decent time to make a suggestion. It occurred to me that Postgres doesn't always do what seem like ...
    BibachBibach
    Feb 26, 1997 at 5:22 pm
    Feb 26, 1997 at 8:38 pm
  • This does, indeed, look like the book to read. However, it appears to not quite be done. Specifically, at the moment I'm having a problem with a query not working quite the way I think it should, and ...
    BibachBibach
    Feb 23, 1997 at 12:20 am
    Feb 23, 1997 at 11:48 pm
  • We are now soliciting Alpha Testers for the Java version of the PostgreSQL libpq interface. With the libpq interface comes a Java version of psql. It has some differences: 1) No support for pipes or ...
    James W. BennettJames W. Bennett
    Feb 10, 1997 at 9:28 pm
    Feb 21, 1997 at 9:42 pm
  • Hi... I just dump'd, rebuilt and reloaded the database server, and so far *cross fingers* that seems to have fixed it. Bruce...its the first time I get a chance to use pg_dumpall... fantastic ...
    The Hermit HackerThe Hermit Hacker
    Feb 20, 1997 at 3:21 pm
    Feb 21, 1997 at 12:57 am
  • Just going through config.h.in looking at what can easily be tested for, I notice that the nextstep port defines: NO_SIGACTION NO_SETSID NO_SIGPROCMASK Doing a grep on the sources comes up with none ...
    The Hermit HackerThe Hermit Hacker
    Feb 6, 1997 at 6:24 am
    Feb 10, 1997 at 6:04 pm
  • gmake clean removes GNUmakefile, so you have to run configure again. Was this intended? ------------------------------
    Bruce MomjianBruce Momjian
    Feb 28, 1997 at 11:52 am
    Feb 28, 1997 at 4:10 pm
  • Hi, I'm still having problems with strdup and NEXTSTEP. configure's correctly = sets #undef HAVE_STRDUP. With the current snapshot, compilation then works = well for all but pg_dump and psql. First, ...
    Gregor HoffleitGregor Hoffleit
    Feb 23, 1997 at 10:34 pm
    Feb 25, 1997 at 11:02 am
  • Vadim... Just thinking about it, and the problem I've been having just may have been my fault *sigh* When you do an 'initdb' to first create the database, it does something with the .bki files, ...
    The Hermit HackerThe Hermit Hacker
    Feb 20, 1997 at 4:16 am
    Feb 20, 1997 at 12:33 pm
  • Hello, I'm not sure if this is the correct list or not. Anyway, I have ported postgresql 6.0 to MkLinux, linux for Power Macintosh, except the dynamic loading functionarity which is not supported by ...
    Tatsuo IshiiTatsuo Ishii
    Feb 4, 1997 at 8:03 am
    Feb 6, 1997 at 8:10 am
  • This is about the error handling in PostgreSQL. I don't like it. There are elog() calls all over the place, which send a more or less explicative text to the client. Now, if you try to write an ...
    Martin J. LaubachMartin J. Laubach
    Feb 28, 1997 at 2:48 pm
    Feb 28, 1997 at 5:51 pm
  • Hi, Just been browsing the Web page and noticed that history.phtml doesn't make any mention of 6.0 --- a bit silly when we have an up-to-date history file in the release :-) Also, the mail.phtml page ...
    Andrew MartinAndrew Martin
    Feb 26, 1997 at 3:00 pm
    Feb 28, 1997 at 8:43 am
  • vac= create table test (x int4); CREATE vac= insert into test values (1); INSERT 3706106 vac= insert into test values (1); INSERT 3706107 vac= create unique index ti on test using btree (x int4_ops); ...
    Vadim B. MikheevVadim B. Mikheev
    Feb 22, 1997 at 10:30 am
    Feb 25, 1997 at 3:38 am
  • Both Pascal (below) and myself have found that Ansi dates don't work on our Sun boxes. This discussion happened over the last couple days on questions@postgresql.org. I thought I'd forward it to ...
    Howard, Dan: CIOHoward, Dan: CIO
    Feb 21, 1997 at 6:04 pm
    Feb 22, 1997 at 10:26 am
  • When using the configure script, I get: creating bin/pg_dump/Makefile creating include/config.h linking ./port/BSD44_derived.h to include/os.h configure: error: ./port/BSD44_derived.h: File not found ...
    ExplorerExplorer
    Feb 12, 1997 at 2:55 am
    Feb 14, 1997 at 2:46 pm
  • Baseline details: Target System: Pentium/75MHz running Unixware 2.03 Compiler Specs: GCC 2.7.2 GNU Make 3.72 GNU Bison 1.24 The 1.09 svr4 port works wonderfully under the environment listed above. ...
    Michael P. SnyderMichael P. Snyder
    Feb 10, 1997 at 6:05 am
    Feb 13, 1997 at 3:31 pm
  • Hi ! I looked trough the sources of Postgres 6.0 and I want to offer to make the changes in strings comparison functions, contained in varchar.c file in /src/backend/utils/adt directory. It needs use ...
    Vasily EgoshinVasily Egoshin
    Feb 11, 1997 at 5:59 am
    Feb 12, 1997 at 1:19 pm
  • Hi, Has anybody managed to get these three to work ? I have it working with apache 1.1. When compiling mod_auth_pg95 with apache beta6 I get a few warnings which are fixed by changing a couple of ...
    Doug SiskDoug Sisk
    Feb 5, 1997 at 6:29 am
    Feb 5, 1997 at 8:00 pm
  • Has anybody run into the problem, when building under Solaris 2.4, of not having definitions for the resource usage stuff in backend/commands/vacuum.c? This would be the struct rusage and the ...
    Brandon IbachBrandon Ibach
    Feb 4, 1997 at 2:08 pm
    Feb 5, 1997 at 4:28 pm
  • This is another question that I asked last Friday and did not receive any kind of an answer. I attribute this to the same mysterious disease that striked down so many brave hackers last Firday. After ...
    LshLsh
    Feb 3, 1997 at 8:19 pm
    Feb 3, 1997 at 11:57 pm
  • I have moved this to the hackers list where it belongs. First, gmake clean in the port directory should remove SUBSYS.o. It currently removes just port/SUBSYS.o. I just applied a patch to do that. ...
    Bruce MomjianBruce Momjian
    Feb 28, 1997 at 11:03 am
    Feb 28, 1997 at 7:53 pm
  • This doesn't look too good: indirect= create table test1 (f1 int4); CREATE indirect= drop table test1; DROP indirect= create table test1 (f1 text, f2 int4); CREATE indirect= insert into test1 values ...
    Dan McGuirkDan McGuirk
    Feb 26, 1997 at 1:02 am
    Feb 28, 1997 at 1:21 pm
  • vac= create table test (x int4); CREATE vac= insert into test values (1); INSERT 2627841 vac= insert into test values (1); INSERT 2627842 vac= create unique index ti on test using btree (x int4_ops); ...
    Vadim B. MikheevVadim B. Mikheev
    Feb 20, 1997 at 4:05 am
    Feb 20, 1997 at 6:49 am
  • Hi... Today I experienced a "bug" that I'm not quite sure how to recreate. I have a table (radlog) that never has any tuples deleted from it, only added to it. Its basically the accounting logs ...
    The Hermit HackerThe Hermit Hacker
    Feb 20, 1997 at 2:06 am
    Feb 20, 1997 at 3:17 am
  • Just compiled the current source, and the second time I get a WARN the backend dies. This leads me to believe that a signal handler is not being reset...? This is under Linux. I now have a patch that ...
    Dan McGuirkDan McGuirk
    Feb 19, 1997 at 12:31 am
    Feb 19, 1997 at 6:25 am
  • Applied... ------------------------------
    The Hermit HackerThe Hermit Hacker
    Feb 12, 1997 at 5:23 am
    Feb 14, 1997 at 4:39 am
  • Request permission to remove the WIN32 stuff. It has never worked to my knowledge, and it is probably so old it is outdated. Any port to WIN32 would have to be done from scratch anyway, so can I ...
    Bruce MomjianBruce Momjian
    Feb 11, 1997 at 7:22 pm
    Feb 13, 1997 at 8:46 am
  • i gave jolly my btree bulkload code a long, long time ago but never gave him a bunch of my bugfixes. here's a diff against the 6.0 baseline. for some reason, this code has slowed down somewhat ...
    Paul M. AokiPaul M. Aoki
    Feb 11, 1997 at 4:02 am
    Feb 13, 1997 at 8:41 am
  • Hello Dear Postgres Developers, I am a novice programmer who is working towards contributing to the development of postgres. My name is Eddie, how do you do? In the past, I've submitted bug reports ...
    IntegrationIntegration
    Feb 10, 1997 at 2:45 pm
    Feb 13, 1997 at 8:38 am
  • Hi Hackers, I've posted a V6.0 bug (see forward) a few days ago. I've heard nothing in the meantime so I would like to ask, if one's working on a fix. I must continue my project (based on V1.02) but ...
    Gerhard ReithoferGerhard Reithofer
    Feb 11, 1997 at 11:15 pm
    Feb 13, 1997 at 8:09 am
  • I asked about this earlier, but didn't get a response in the heat of the v6.0 beta testing... I would like to contribute fixes and upgrades to the geometry stuff, which doesn't really hang together ...
    Thomas LockhartThomas Lockhart
    Feb 12, 1997 at 12:24 am
    Feb 12, 1997 at 3:10 pm
  • Nice description of the problem. I have applied the following patch to the current sources to fix the problem. Let me know if this does not fix the problem. - ...
    Bruce MomjianBruce Momjian
    Feb 11, 1997 at 11:08 pm
    Feb 12, 1997 at 1:27 pm
  • I have added your name to the TODO list with a question mark, if that is ok. RELIABILITY - ----------- Fix compile and security of Kerberos code (Daniel Kalchev?) ------------------------------
    Bruce MomjianBruce Momjian
    Feb 11, 1997 at 9:57 pm
    Feb 12, 1997 at 4:57 am
  • I have been trying to install the new version 6.0. The compile part works just great but as soon as I get to the linking part it dies. The error message that I get is "gcc: Internal compiler error: ...
    Brian WeberBrian Weber
    Feb 10, 1997 at 6:49 am
    Feb 11, 1997 at 12:52 am
  • I can compile on solaris 2.5 ... the standard outpout of gmake ... gcc -Wall -Wmissing-prototypes -O2 -Werror -Dsparc_solaris -I../../backend/port /sparc_solaris -I.. -I../port/sparc_solaris ...
    MAS ErwanMAS Erwan
    Feb 12, 1997 at 4:30 pm
    Feb 28, 1997 at 11:19 am
  • Hi... Just made a slight change to configure that I hope will fix the problem with strdup.o not being used as required. Please let me know if this does, in fact, fix the problem...or, if it doesn't ...
    The Hermit HackerThe Hermit Hacker
    Feb 25, 1997 at 6:13 pm
    Feb 27, 1997 at 4:36 pm
  • Hi... Sort of related to the problems I'm experiencing, but has there been any major changes to btree indices (ie. bulkload?) that would drastically change the size of the resultant file? I ...
    The Hermit HackerThe Hermit Hacker
    Feb 20, 1997 at 1:05 pm
    Feb 22, 1997 at 9:39 am
  • Our happy happy hacker posted a procmailrc for the postgres lists. I felt that (a) most of the astericks that were there probably were supposed to be proceeded with a period (otherwise the asterick ...
    Christopher HicksChristopher Hicks
    Feb 21, 1997 at 7:46 am
    Feb 21, 1997 at 1:08 pm
  • Hi, I was told that Postgres is an excellent DBMS in handling geometric/spatial objects such as polygons. I read through the manual, the FAQ, and the examples and couldn't find anything about it ...
    ContactContact
    Feb 20, 1997 at 12:33 pm
    Feb 20, 1997 at 7:06 pm
  • Hello, I have a mid-January copy of postgres (just pre 6.0 release). I am having a continuous problem with queries with unmatched 's. if I do select something from somewhere where field ~* 'freddy' ...
    IntegrationIntegration
    Feb 17, 1997 at 3:37 pm
    Feb 17, 1997 at 7:26 pm
  • In response to Dan McGuirk <mcguirk@indirect.com 's comments re. problems with flex 2.5.3, here's a patch to INSTALL which asks people to check they are not using 2.5.3. (Could autoconf check the ...
    Andrew MartinAndrew Martin
    Feb 17, 1997 at 11:16 am
    Feb 17, 1997 at 4:42 pm
  • Very minor, I know, but the README file in .../src/test/regress still refers to Postgres95. Here's a patch: *** README.old Mon Feb 10 09:52:57 1997 - --- README Mon Feb 10 09:53:25 1997 ...
    Andrew MartinAndrew Martin
    Feb 10, 1997 at 9:55 am
    Feb 14, 1997 at 4:59 am
  • The original poster did not specify which machine he was running on. If it was linux, it would mean that postgres6.0 has achieved the distinction of being as tough to compile as the Linux kernel ...
    Cary B. O'BrienCary B. O'Brien
    Feb 10, 1997 at 2:38 pm
    Feb 13, 1997 at 8:52 am
  • With the following set of patches, I was able to compile the 970211 snapshot for NEXTSTEP (Intel, other archs should work as well). The server starts up, but fails every few commands. My replacement ...
    Gregor HoffleitGregor Hoffleit
    Feb 11, 1997 at 11:29 am
    Feb 13, 1997 at 8:33 am
Feb 1997
123
Group Navigation
period‹ prev | Feb 1997 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions114
posts297
users71
websitepostgresql.org...
irc#postgresql

71 users for February 1997

Bruce Momjian: 59 posts The Hermit Hacker: 58 posts Vadim B. Mikheev: 19 posts Andrew Martin: 15 posts Thomas Lockhart: 9 posts Dan McGuirk: 8 posts Brandon Ibach: 7 posts Michael Graff: 7 posts Darren King: 6 posts Lsh: 4 posts Edmund Mergl: 4 posts Gregor Hoffleit: 4 posts James Hughes: 4 posts Michael P. Snyder: 4 posts Alexander Kruchkoff: 3 posts Alvaro Martinez Echevarria: 3 posts Brian Weber: 3 posts Burak DAYIOGLU: 3 posts Doug Sisk: 3 posts Jeffrey F. Lawhorn: 3 posts
show more
Archives