FAQ

Search Discussions

214 discussions - 1,207 posts

  • We still have some release-stoppper items on this list. I need to integrate the cidr type into the system. --------------------------------------------------------------------------- Possible ...
    Bruce MomjianBruce Momjian
    Oct 2, 1998 at 6:30 am
    Oct 31, 1998 at 4:49 pm
  • Hi. I believe we are still shooting for a Nov 1 release, though without reports of successful regression tests on more platforms I'm not sure we can do that. I know that at least some of those listed ...
    Thomas G. LockhartThomas G. Lockhart
    Oct 25, 1998 at 4:28 am
    Oct 30, 1998 at 12:35 am
  • i'm not familiar with mysql and using "LIMIT" but wouldn't this same effect be achieved by declaring a cursor and fetching however many records in the cursor? it's a very noticeable improvement when ...
    Jeff HoffmannJeff Hoffmann
    Oct 13, 1998 at 7:20 pm
    Oct 22, 1998 at 1:52 pm
  • i would very much like inet_net_pton to not be changed in this way, even though it's an internal server function the way postgres 6.4 will be packaged. there is an RFC specifying what this function ...
    Paul A VixiePaul A Vixie
    Oct 10, 1998 at 4:10 am
    Oct 21, 1998 at 2:59 am
  • How are people handling the fact that libpq is dynamic, and psql needs to find it. I don't see people using -rpath as a link option. Are people setting LD_LIBRARY_PATH to the PostgreSQL library ...
    Bruce MomjianBruce Momjian
    Oct 9, 1998 at 5:10 pm
    Oct 13, 1998 at 6:39 pm
  • As long as we're doing last-minute changes that force initdb ... I believe I've just identified another error in pg_operator.h. Specifically, this tuple is bogus and ought to be deleted: DATA(insert ...
    Tom LaneTom Lane
    Oct 28, 1998 at 8:50 pm
    Oct 30, 1998 at 2:21 am
  • I just built and regression tested the current source tree on both Solaris x86 and Solaris Sparc, and other then a few bugs that I've fixed, it was smooth... Any arguments against getting a BETA2 out ...
    Marc G. FournierMarc G. Fournier
    Oct 13, 1998 at 10:50 pm
    Oct 15, 1998 at 4:29 pm
  • I started out with a Makefile.custom which has in it the following: USE_TCL= true TCL_LIB= -ltcl X_LIBS= -L/usr/X11/lib TK_LIB= -ltk Did a "configure", without specifying --with-tcl, then did a "make ...
    Thomas G. LockhartThomas G. Lockhart
    Oct 27, 1998 at 2:46 pm
    Oct 29, 1998 at 6:27 am
  • [Charset iso-8859-1 unsupported, filtering to ASCII...] [Moved to Hackers list.] This is interesting. Check CNF size and DNF size. Choose smallest. CNF uses existing code, DNF converts to UNIONs. How ...
    Bruce MomjianBruce Momjian
    Oct 2, 1998 at 6:31 am
    Oct 7, 1998 at 9:33 pm
  • Hello! I tried postgresql.v6.4-BETA3 and found some problems especially with FreeBSD. The following is my environment: FreeBSD 2.2.7-RELEASE GNU Make version 3.76.1, by Richard Stallman and Roland ...
    SHIOZAKI TakehikoSHIOZAKI Takehiko
    Oct 30, 1998 at 1:10 am
    Nov 2, 1998 at 3:28 pm
  • chmod 755 blib/arch/auto/Pg/Pg.so cp Pg.bs blib/arch/auto/Pg/Pg.bs chmod 644 blib/arch/auto/Pg/Pg.bs Manifying blib/man3/Pg.3 mkdir /usr/local/lib/perl5/site_perl: No such file or directory at \ ...
    The Hermit HackerThe Hermit Hacker
    Oct 27, 1998 at 6:18 am
    Oct 29, 1998 at 6:10 am
  • I have recieved the files from D'Arcy for new INET and CIDR types. INET is use for hosts, while CIDR for networks. No duplicate code. CIDR behaves the same as INET, except for a different input ...
    Bruce MomjianBruce Momjian
    Oct 21, 1998 at 6:13 am
    Oct 29, 1998 at 1:54 pm
  • I am having problems getting the perl interface to work (but see below for a fix). If I install postgresql on a bare system (i.e., one with no previous postgresql installed), the perl interface gets ...
    Brook MilliganBrook Milligan
    Oct 14, 1998 at 4:55 pm
    Oct 19, 1998 at 10:59 pm
  • Hi, I took a look at mysql and was very impressed with possibility to limit number of rows returned from select. This is very useful feature for Web applications when user need to browse results of ...
    Oleg BartunovOleg Bartunov
    Oct 13, 1998 at 5:32 pm
    Oct 15, 1998 at 4:48 am
  • Here is a report regarding the backend-crash from a user in Japan. Included shell script should reproduce the phenomenon. Note that select * from getting; vacuum; does cause a crash, while select * ...
    Tatsuo IshiiTatsuo Ishii
    Oct 2, 1998 at 3:45 am
    Oct 12, 1998 at 7:33 am
  • I believe Tom Lane removed the double-backslash from the psql output by modifying PQprint. I recommend that is reversed, because psql escapes out the table column delimiters with a single backslash, ...
    Bruce MomjianBruce Momjian
    Oct 9, 1998 at 8:25 pm
    Oct 18, 1998 at 6:42 pm
  • On Friday morning, I'm going to be tagging the PostgreSQL source tree as STABLE-6_4, and will be creating a new BETA tar ball. Normal development will be able to continue, while we will be able to ...
    Marc G. FournierMarc G. Fournier
    Oct 21, 1998 at 7:42 pm
    Oct 22, 1998 at 5:33 pm
  • Hi all, currently CVS is not working. It gives the following error message: marliesle:/usr/local/pgsql# cvs -z3 update -d Fatal error, aborting. : no such user -Egon
    Egon SchmidEgon Schmid
    Oct 18, 1998 at 5:45 am
    Oct 18, 1998 at 8:32 pm
  • Oops...too late :) Someone close to Tom want to break his fingers for me? :) Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Oct 29, 1998 at 4:40 am
    Oct 30, 1998 at 2:19 am
  • Attached is the up-to-date 6.4 features list. I will keep this up-to-date, until the final release. --------------------------------------------------------------------------- CHANGES IN THE 6.4 ...
    Bruce MomjianBruce Momjian
    Oct 24, 1998 at 4:17 am
    Oct 26, 1998 at 4:49 pm
  • Terry MackintoshTerry Mackintosh
    Oct 3, 1998 at 8:13 pm
    Oct 13, 1998 at 2:33 pm
  • I went to test my functions but got the following. darcy= select '198.1.2.3/8'::inet; ERROR: type name lookup of inet failed Was the type backed out while waiting for completion? Any chance of ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Oct 15, 1998 at 4:58 pm
    Oct 17, 1998 at 5:19 pm
  • After looking into the issue of using PID file locks vs. flock/unlock, I have come to the following conclusions: 1. It is generally agreed that a PID lock file should replace the current me- thod of ...
    Billy G. AllieBilly G. Allie
    Oct 11, 1998 at 12:51 am
    Oct 15, 1998 at 2:33 pm
  • Hi, I have successeed in porting PostgreSQL to Win NT. The patch that is included is for development version from Sep 15, but I think that the changes are version independent. The main difference ...
    Horak DanielHorak Daniel
    Oct 7, 1998 at 12:05 pm
    Oct 9, 1998 at 4:43 pm
  • Hi, all. I am testing 6.4 on a DU 4.0d system using DEC's (well, Compaq's) C compiler, gmake 3.75, bison 1.25 and flex 2.5.4, and I've found two problems. 1 - The old "configure --with-CC=cc" problem ...
    Pedro J. LoboPedro J. Lobo
    Oct 29, 1998 at 11:31 am
    Oct 30, 1998 at 12:26 am
  • I see there are at least other two options for SET/SHOW/RESET commands: - KSQO - QUERY_LIMIT I would to underline the help is not updated about KSQO: hygea= \h show Command: show Description: show ...
    José SoaresJosé Soares
    Oct 22, 1998 at 9:55 am
    Oct 26, 1998 at 3:07 am
  • Does anyone understand why configure.in wants to include libcurses in $(LIBS) ? There is no program in the PostgreSQL distribution that uses that library (at least, I could not find any reference to ...
    Tom LaneTom Lane
    Oct 30, 1998 at 11:54 pm
    Nov 2, 1998 at 8:28 am
  • Hmm. I know what I _think_ about y2k on Postgres (no problem), but I'm not sure what your admin team is looking for here (besides an excuse to avoid work -- *slap* ooh, that wasn't nice was it?). I'm ...
    Thomas G. LockhartThomas G. Lockhart
    Oct 22, 1998 at 5:29 pm
    Oct 24, 1998 at 2:07 pm
  • Two seperate questions.. 1) Is there any reason why I can't create a unique index on an int8? It tells me this: ERROR: Can't find a default operator class for type 20. 2) Are there any more changes ...
    Vince VielhaberVince Vielhaber
    Oct 18, 1998 at 9:42 pm
    Mar 15, 1999 at 2:12 pm
  • Someone checked in code that assumes vsnprintf() exists. Should be cool, we have an emulation right? Well, no. configure sets up to build port/snprintf.c if snprintf() doesn't exist. HPUX, for one, ...
    Tom LaneTom Lane
    Oct 27, 1998 at 10:51 pm
    Dec 11, 1998 at 5:03 pm
  • Hi. I just built postgresql 6.4 beta 4 on HPUX 10.01. This was not a clean compile +, and I had to make minor modifications to get it to compile. First of all, hpux 10.01 does not define SA_RESTART ...
    MschoutMschout
    Oct 30, 1998 at 8:02 pm
    Nov 1, 1998 at 6:27 pm
  • Hi, there seems to be a problem with the relation statistics in pg_class. Could someone explain why this happens? doc= vacuum; VACUUM doc= select relname, relpages, reltuples from pg_class doc- where ...
    Jan WieckJan Wieck
    Oct 22, 1998 at 7:19 pm
    Oct 24, 1998 at 8:27 am
  • I think this is a non issue, since if a qual is not restrictive enough, the optimizer should choose a seq scan anyway. Doesn' t it do this already ? I would reformulate this to: Here the backend ...
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 15, 1998 at 8:56 am
    Oct 15, 1998 at 4:29 pm
  • The configure script is not correctly substituting the TCL/TK libraries it finds. Please remember that setting variables in the configure script is not enough to get them substituted into Makefiles ...
    Brook MilliganBrook Milligan
    Oct 12, 1998 at 5:27 pm
    Oct 13, 1998 at 3:31 pm
  • OK, I'm about ready to freeze the admin guide and installation info. I'd like to put the TODO list into the release notes, along with a few paragraphs highlighting feature improvements/changes which ...
    Thomas G. LockhartThomas G. Lockhart
    Oct 30, 1998 at 3:13 pm
    Oct 31, 1998 at 3:58 am
  • as most of you know by now, jon postel, the original IANA, died last week. i'm sorry that i've been so flakey in my correspondance here but it's been a rough time for those of us who knew him and/or ...
    Paul A VixiePaul A Vixie
    Oct 21, 1998 at 12:47 am
    Oct 21, 1998 at 7:39 pm
  • Hello all, I have a table SP with a primary key SNO, I'm trying if v6.4beta2 uses indexes but seems it uses indexes only with '=' operator: prova= explain select * from sp where sno = 'S1'; NOTICE: ...
    Sferacarta SoftwareSferacarta Software
    Oct 19, 1998 at 11:17 am
    Oct 20, 1998 at 4:53 pm
  • There is some code in libpgtcl that purports to convert Postgres array data values into Tcl lists. Is anyone prepared to argue that that code does something useful in its present state? I can name ...
    Tom LaneTom Lane
    Oct 4, 1998 at 10:24 pm
    Oct 11, 1998 at 7:48 pm
  • Just curious, what functions did we finally settle on for this type? I ask because I just thought of another function that might be useful. select block(cidr1, cidr2); to return 1 if cidr2 is part of ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Oct 9, 1998 at 4:15 am
    Oct 10, 1998 at 2:00 pm
  • I have had a few problems with the PL stuff recently committed. The following patches fix the problems (i.e., all regression tests pass) in what I hope to be a platform-independent fashion. The ...
    Brook MilliganBrook Milligan
    Oct 8, 1998 at 5:27 pm
    Oct 9, 1998 at 4:44 pm
  • I have implemented a regproc fix. Now, if you supply just the pg_proc.proname, and it is unique, you can use it. If there is more than one match for that proname, it prints a message saying you have ...
    Bruce MomjianBruce Momjian
    Oct 2, 1998 at 5:30 am
    Oct 2, 1998 at 4:22 pm
  • somehow current CVS configure does not detect that $CC -E is not working on AIX and therefore configures xlc -E as preprocessor. It should be /lib/cpp ??? Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 27, 1998 at 4:50 pm
    Oct 29, 1998 at 10:12 am
  • Hi, AIX 4.2.1 regression tests are ok :-) int2 .. failed other errmsg (ok) int4 .. failed other errmsg (ok) float8 .. failed has correct output / expected is wrong (ok) geometry .. failed rounding ...
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 28, 1998 at 9:54 am
    Oct 29, 1998 at 4:47 am
  • I guess it's too late for 6.4 so hopefully there is already a way to find out whether a field was declared as a serial type. Am I stuck using some sort of index name hack? -- D'Arcy J.M. Cain ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Oct 25, 1998 at 1:50 pm
    Oct 26, 1998 at 5:35 pm
  • The attached patches affect the following areas: 1. The make file for 'bin/pgtclsh' was failing on my system because the tcl/tk libraries could not be found. I have changed the make file so that it ...
    Billy G. AllieBilly G. Allie
    Oct 11, 1998 at 12:31 am
    Oct 12, 1998 at 4:45 am
  • Merged into the current source tree. Please test. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ ...
    Bruce MomjianBruce Momjian
    Oct 3, 1998 at 5:46 am
    Oct 8, 1998 at 7:15 am
  • Funny you should ask... I'm just in the process of converting all of the "utilities" man pages to sgml. For this release, we should keep the man pages as-is, but we will have equivalent info in ...
    Thomas G. LockhartThomas G. Lockhart
    Oct 4, 1998 at 10:58 pm
    Oct 5, 1998 at 2:43 pm
  • Any objections to my putting out a BETA3 late tomorrow afternoon? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Oct 27, 1998 at 3:10 am
    Nov 1, 1998 at 6:52 pm
  • Ok, here they are, the long awaited patches to make pgsql compile once again on Linux/Alpha. It turned out that our old friend S_LOCK was the problem. Apparently some one had pulled the S_LOCK ...
    Ryan KirkpatrickRyan Kirkpatrick
    Oct 31, 1998 at 1:54 am
    Oct 31, 1998 at 3:17 pm
  • This is a diff of several regression tests I run on my Linux box (last cvs): dv:~/cvs/pgsql/src/test/regress$ diff results/opr_sanity.out expected/opr_sanity.out 54,58c54,56 < oid|oprcode ...
    Oleg BartunovOleg Bartunov
    Oct 29, 1998 at 12:18 pm
    Oct 29, 1998 at 7:54 pm
Group Navigation
period‹ prev | Oct 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions214
posts1,207
users102
websitepostgresql.org...
irc#postgresql

102 users for October 1998

Bruce Momjian: 302 posts Thomas G. Lockhart: 146 posts Tom Lane: 106 posts The Hermit Hacker: 93 posts Jan Wieck: 79 posts D'Arcy J.M. Cain: 58 posts Taral: 33 posts Billy G. Allie: 32 posts Brook Milligan: 28 posts Paul A Vixie: 20 posts Tom Ivar Helbekkmo: 20 posts Tatsuo Ishii: 17 posts Oleg Bartunov: 16 posts Terry Mackintosh: 16 posts Matthew N. Dodd: 15 posts Andreas Zeugswetter: 13 posts Vince Vielhaber: 12 posts Peter T Mount: 10 posts Sferacarta Software: 9 posts Frank Ridderbusch: 8 posts
show more
Archives