FAQ

PostgreSQL > pgsql-hackers > September 1998

Search Discussions

158 discussions - 678 posts

  • I am still waiting for the first report from my index fix. Anyone? -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | ...
    Bruce MomjianBruce Momjian
    Sep 3, 1998 at 4:21 am
    Sep 9, 1998 at 4:05 am
  • In the constraints test, a table (primary_tbl) is defined with a primary key. The table is created, shows up in the list of table using the \dt command, but does not exist if you use the \d command, ...
    Billy G. AllieBilly G. Allie
    Sep 8, 1998 at 8:06 am
    Sep 10, 1998 at 6:30 am
  • Not if he is trying to display the complement of a logical field rather than restrict a selection. And regardless, is backend failure an acceptable out? How about the following in 6.4beta? create ...
    Christopher OliverChristopher Oliver
    Sep 18, 1998 at 6:02 pm
    Sep 22, 1998 at 5:02 am
  • 15

    SQL92

    Does the SQL92 standard have to be purchased from the ANSI Board? Well, my actual question has to do with LIKE. Could anyone who has a copy of a standard send me the PATTERN syntax/meanings for LIKE ...
    Jackson, DeJuanJackson, DeJuan
    Sep 29, 1998 at 2:51 pm
    Oct 2, 1998 at 4:24 pm
  • Hi All, I can't confirm this against the current latest CVS as my local tree has undergone some changes, but we seem to have a problem with "pg_dump" and user defined types. If I create a type like ...
    Keith ParksKeith Parks
    Sep 23, 1998 at 10:11 am
    Sep 25, 1998 at 3:51 pm
  • OK, I have a current version of PostgreSQL running on my pc532 now. (It's a NS32K based machine. Somewhat of an antique really...) I had to apply the following diffs to get it to compile, but it then ...
    Jon BullerJon Buller
    Sep 14, 1998 at 12:16 am
    Sep 19, 1998 at 12:06 am
  • Hi, I am experiencing missing header files. I am not suprised but I would like to have any missing header file. If I have them I could attempt to write /find them on my system. Can I access them ...
    Joost KraaijeveldJoost Kraaijeveld
    Sep 10, 1998 at 6:21 pm
    Sep 15, 1998 at 4:40 am
  • I have finally resolved the differences in the union regression test. The problem is that the test uses the float8 table as part of the test, and this table turns out to be different among platforms ...
    Brook MilliganBrook Milligan
    Sep 16, 1998 at 8:25 pm
    Sep 22, 1998 at 4:53 pm
  • That would be me. What I said was that it looked like the thing to do was to pick the best ideas the three implementations available, and that I, at least, would be doing that for my local needs. I ...
    Tom Ivar HelbekkmoTom Ivar Helbekkmo
    Sep 4, 1998 at 7:46 am
    Sep 8, 1998 at 5:36 pm
  • Hi All. I tested libpq for win32 coming with 6.4-BETA and have a question about LIBPQ. I used LIBPQ from a C program,but coundn't connect PostgreSQL DB. Calling pg_connect() without WSAStartup() ...
    Hiroshi InoueHiroshi Inoue
    Sep 28, 1998 at 4:06 am
    Oct 1, 1998 at 10:55 am
  • I have a couple minor issues regarding the 6.4 implementation of the SERIAL data type. I like the ease of using the serial data type and I suspect it will be used frequently base on the number of ...
    David HartwigDavid Hartwig
    Sep 11, 1998 at 8:30 pm
    Sep 16, 1998 at 1:16 pm
  • Tom, I tried the int8 type onder BSD/OS, running 6.3.2 (contrib/int8). There the %Ld type is unimplemented and %lld or %qd both work. For BSD/OS 3.1, since DLSUFFIX is .o (static shared libraries), ...
    Daniel KalchevDaniel Kalchev
    Sep 10, 1998 at 3:24 pm
    Sep 11, 1998 at 5:08 pm
  • I tried adding the PRIMARY KEY info to pg_class but the resulting data base system simply dumps core everywhere. Can someone point me to the areas that need to be addressed? Here's what I did. I ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Sep 2, 1998 at 12:08 pm
    Sep 9, 1998 at 6:26 pm
  • This is a very recent addition at line 664 of copy.c It will not compile on AIX 4.1 Help! gmake[2]: Entering directory `/gnu/postgresql-6.4f/src/backend/commands' xlc -I../../include -I../../backend ...
    David HartwigDavid Hartwig
    Sep 7, 1998 at 10:29 pm
    Sep 8, 1998 at 10:29 pm
  • This query crashes the backend. pg_rules is a new system view: BEGIN WORK; DECLARE c_matches BINARY CURSOR FOR SELECT count(*) FROM pg_attrdef t1, pg_rules t2 WHERE t1.adrelid = t2.oid END WORK; ...
    Bruce MomjianBruce Momjian
    Sep 13, 1998 at 8:28 pm
    Sep 25, 1998 at 9:30 am
  • Open portability issues: /usr/local should be searched for lib and include for all ports if present (currently not working, I have libreadline there) the stream functions on AIX need a size_t for ...
    Andreas ZeugswetterAndreas Zeugswetter
    Sep 4, 1998 at 7:11 pm
    Sep 10, 1998 at 12:33 pm
  • Yes, the NULL works for parameters of an update statement, where Access would specify a statement such as "update table set param = ? where x = 1". But it doesn't work in a select statement. I don't ...
    Byron NikolaidisByron Nikolaidis
    Sep 17, 1998 at 10:15 pm
    Oct 27, 1998 at 3:54 pm
  • There's been a very recent change to include the OID in certain names in the system table. Do a "select * from pg_amop;" to see what I mean: the values for amopselect and amopnpages didn't have the ...
    Tom Ivar HelbekkmoTom Ivar Helbekkmo
    Sep 11, 1998 at 8:37 am
    Oct 2, 1998 at 2:49 pm
  • Michael ReifenbergerMichael Reifenberger
    Sep 20, 1998 at 6:51 pm
    Sep 23, 1998 at 5:52 pm
  • Morning... Well, as of 00:40EST, there is a BETA1 available at ftp.postgresql.org:/pub/postgresql.v6.4-BETA1.tar.gz ... I've add a README-1ST file to the top level that is meant to provide a listing ...
    The Hermit HackerThe Hermit Hacker
    Sep 14, 1998 at 4:44 am
    Sep 16, 1998 at 12:01 pm
  • -----BEGIN PGP SIGNED MESSAGE----- select min(oid) from pg_class; ERROR: function min(oid) does not exist I got this surprise while trying to optimize a hack for the PostgreSQL functions in Keystone ...
    Roland RobertsRoland Roberts
    Sep 5, 1998 at 12:33 am
    Sep 5, 1998 at 9:35 pm
  • I've got this new notify code almost working, but... What exactly is the protocol for locking a table that you intend to modify? The old notify code just did RelationSetLockForWrite(), but it's not ...
    Tom LaneTom Lane
    Sep 27, 1998 at 9:34 pm
    Oct 2, 1998 at 2:24 am
  • Hi, I checked latest cvs and notice when I do 'vacuum analyze' I got: flats= vacuum analyze; NOTICE: AbortTransaction and not in in-progress state NOTICE: AbortTransaction and not in in-progress ...
    Oleg BartunovOleg Bartunov
    Sep 12, 1998 at 7:23 pm
    Sep 14, 1998 at 3:02 am
  • I have been looking into the problem reported by Massimo, and also seen by me, that backends sometimes exit without cleaning up entries they made in the pg_listener table. I have fixed several ...
    Tom LaneTom Lane
    Sep 28, 1998 at 2:28 pm
    Oct 2, 1998 at 2:25 am
  • Is this an error on my part or is there a bug in the CREATE TRIGGER code? darcy= CREATE FUNCTION function_dead(int) darcy- RETURNS int darcy- AS 'UPDATE bid SET live = \'f\' WHERE item_id = $1; ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Sep 20, 1998 at 4:45 am
    Sep 25, 1998 at 5:48 pm
  • Hi... I was thinking in a major rewrite of the PostrgreSQL transaction system, in order to provide less tuple overhead and recoverabilty. My first goal is to reduce tuple overhead, getting rid of ...
    Robson MirandaRobson Miranda
    Sep 16, 1998 at 9:36 pm
    Sep 25, 1998 at 2:43 am
  • At this point the Irix port is nearly complete. There are two problems that remain. First, the snprintf function does not process the %lld format correctly. Frankly, there is no reason to use it in ...
    Robert BruccoleriRobert Bruccoleri
    Sep 20, 1998 at 3:50 am
    Sep 24, 1998 at 1:13 am
  • interesting that select * from work_flats where (METRO_ID = 81 or METRO_ID = 82) and DISTRICT_ID < 11; crashes backend pqReadData() -- backend closed the channel unexpectedly. This probably means the ...
    Oleg BartunovOleg Bartunov
    Sep 15, 1998 at 7:52 pm
    Sep 21, 1998 at 11:31 am
  • Bruce, here is the patch that includes PL/pgSQL into the build (currently with make errors ignored) and adds a regression test for it. A clean build and regression ran fine here. Can you please apply ...
    Jan WieckJan Wieck
    Sep 29, 1998 at 10:03 am
    Oct 2, 1998 at 4:22 pm
  • I was working on docs and notice that Postgres no longer responds with a warning if a database is dropped multiple times: postgres= drop database yahoo; DESTROYDB postgres= drop database yahoo; ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 22, 1998 at 1:49 pm
    Sep 25, 1998 at 2:39 pm
  • Somehow different. It may be the difference between a pointer to a list of int pointers, and a pointer to a pointer to a list of ints. Does that make sense? -- Bruce Momjian | 830 Blythe Avenue ...
    Bruce MomjianBruce Momjian
    Sep 21, 1998 at 12:37 pm
    Sep 23, 1998 at 2:00 am
  • Compiled with Makefile.custom: (gdb) where #0 0x80dacfc in nodeHandleViewRule (nodePtr=0x40af1ffc, rtable=0x40b8bff4, targetlist=0x40b3bff4, rt_index=1, modified=0xbfffbb90, sublevels_up=0) at ...
    TaralTaral
    Sep 10, 1998 at 7:59 pm
    Sep 19, 1998 at 4:00 am
  • I have found BSDI used %qd for long long, while gnulibc used %Ld. I have changed HAVE_LONG_LONG_INT_64 to be HAVE_LONG_LONG_INT_64_Ld and added HAVE_LONG_LONG_INT_64_qd, and added the proper changes. ...
    Bruce MomjianBruce Momjian
    Sep 10, 1998 at 3:35 am
    Sep 10, 1998 at 5:36 am
  • Hi David! On Mon, 07 Sep 1998 10:56:21 -0400, David Hartwig wrote: First of all I want to thank you for your mail. can't connect to the database. The logfile Well, I gave it a try. Typically M$ :-( ...
    Gerald FischerGerald Fischer
    Sep 7, 1998 at 8:37 pm
    Sep 8, 1998 at 2:26 pm
  • I'm getting: make -C pl clean make[1]: Entering directory `/home/djackson/pgsql/src/pl' make[1]: *** No rule to make target `clean'. Stop. make[1]: Leaving directory `/home/djackson/pgsql/src/pl' ...
    Jackson, DeJuanJackson, DeJuan
    Sep 30, 1998 at 4:08 pm
    Oct 5, 1998 at 5:59 am
  • subscribe
    Chandrashekar T S (MICO/PPI9)Chandrashekar T S (MICO/PPI9)
    Sep 15, 1998 at 3:48 am
    Sep 30, 1998 at 4:18 pm
  • I don't like implementation of referential integrity constraints in contrib/spi/refint.* and implementation of ... unique indices: backend checks constraints when tuple is changed. Oracle checks ...
    Vadim MikheevVadim Mikheev
    Sep 25, 1998 at 3:53 am
    Sep 25, 1998 at 5:08 pm
  • ALERT - cc'd to pgsql-hackers since this looks like a bug in the parser to me. In a word Yes - it looks like the parser simply doesn't understand your SQL and craps out on it. I write this as: select ...
    Chris JohnsonChris Johnson
    Sep 23, 1998 at 12:54 pm
    Sep 24, 1998 at 1:49 pm
  • The query generated by \df causes the backend to fail in oid8types. The simplest illustration I found was: SELECT oid8types(proargtypes) FROM pg_proc; It appears that oid8types() originally expected ...
    Christopher OliverChristopher Oliver
    Sep 18, 1998 at 3:29 am
    Sep 22, 1998 at 8:01 pm
  • Hi all, PostgreSQL gives me a strange message when I try to create a table with a NOT NULL column. drop table prova; DROP create table prova( campo1 INTEGER ); CREATE drop table prova; DROP create ...
    José SoaresJosé Soares
    Sep 17, 1998 at 1:58 pm
    Sep 21, 1998 at 3:04 pm
  • Hi, please apply following patches to rewrite/rewriteManip.c. This seems to fix the "pg_user problem." (I am not very familiar with the rule/rewrite area, so my understanding may be wrong) The ...
    Tatsuo IshiiTatsuo Ishii
    Sep 11, 1998 at 2:02 pm
    Sep 12, 1998 at 5:23 am
  • I just compiled up the current snapshot for a test under netbsd 1.3.2/i386. Everything works except the followng: int8 .. failed <-- seems like large numbers show as negative geometry .. failed <-- ...
    Brook MilliganBrook Milligan
    Sep 9, 1998 at 5:31 pm
    Sep 10, 1998 at 11:48 pm
  • I have come across a situation with 6.4 which has rendered at least some of my home made data types unusable. Specifically, the data type, accntnum, is a General Ledger account number type. (i.e. ...
    David HartwigDavid Hartwig
    Sep 9, 1998 at 9:18 pm
    Sep 10, 1998 at 9:30 pm
  • Hi, I've found the following SISGEV while playing around with a snapshot of September 3rd. I did a make all (with -g); make install; rm -rf data; initdb Here's what I've done in gdb: ...
    Jeroen van VianenJeroen van Vianen
    Sep 6, 1998 at 3:46 pm
    Sep 7, 1998 at 4:50 pm
  • Bruce mentioned that he'd had some trouble applying my last set of patches, because he'd already run his reformatting script against the files involved. So, I took the trouble to grovel through a ...
    Tom LaneTom Lane
    Sep 4, 1998 at 4:25 am
    Sep 4, 1998 at 3:57 pm
  • In transcribing Jose's reference page docs, I've come across examples where Jose has exposed deficiencies in Postgres' support of SQL92. I've fixed several (easier than transcribing more words :) and ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 2, 1998 at 3:07 pm
    Sep 3, 1998 at 1:17 am
  • It's easy: just destroydb one database that has active backends still running in it. Then stand back and watch the carnage. (Hint: back up all your *other* databases first, because you'll be lucky if ...
    Tom LaneTom Lane
    Sep 25, 1998 at 10:18 pm
    Mar 15, 1999 at 2:12 pm
  • Hi, I wonder if anyone ever played around with PL/pgSQL. So far (except for the missing Makefile) I got no response if it compiles/works on other platforms than my Linux. Since there are only a few ...
    Jan WieckJan Wieck
    Sep 29, 1998 at 7:25 am
    Sep 29, 1998 at 9:34 pm
  • Well, I've spent the last several hours studying how NOTIFY works, and I think it's a mess :-(. We need some significant revisions in there. I have not been able to trace an exact flow of control ...
    Tom LaneTom Lane
    Sep 27, 1998 at 1:05 am
    Sep 28, 1998 at 7:15 pm
  • I've got a production application (currently running on 6.3.2 + Btree patch) in which several clients concurrently update the same set of tables. The client requests are pretty simple --- SELECTs ...
    Tom LaneTom Lane
    Sep 23, 1998 at 9:04 pm
    Sep 26, 1998 at 10:03 pm
Sep 1998
1234
Group Navigation
period‹ prev | Sep 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions158
posts678
users78
websitepostgresql.org...
irc#postgresql

78 users for September 1998

Bruce Momjian: 170 posts Thomas G. Lockhart: 103 posts David Hartwig: 27 posts The Hermit Hacker: 26 posts Tom Lane: 26 posts Tatsuo Ishii: 24 posts Vadim Mikheev: 21 posts Keith Parks: 18 posts D'Arcy J.M. Cain: 14 posts Jan Wieck: 14 posts Michael Meskes: 14 posts Andreas Zeugswetter: 13 posts Brook Milligan: 13 posts Billy G. Allie: 12 posts David Hartwig: 11 posts Joost Kraaijeveld: 10 posts Sferacarta Software: 10 posts Oleg Bartunov: 9 posts Jackson, DeJuan: 8 posts Taral: 8 posts
show more
Archives