Search Discussions
-
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 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. 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 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, 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 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 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 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 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 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 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 Hartwig
Sep 11, 1998 at 8:30 pm
Sep 16, 1998 at 1:16 pm -
10
more on int8
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 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. 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 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 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 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 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 Helbekkmo
Sep 11, 1998 at 8:37 am
Oct 2, 1998 at 2:49 pm -
Michael 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 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 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 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 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 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. 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 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 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 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 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. 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 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 ...
Taral
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 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 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, DeJuan
Sep 30, 1998 at 4:08 pm
Oct 5, 1998 at 5:59 am -
subscribe
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 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 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 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é 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 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 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 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 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 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. 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 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 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 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 Lane
Sep 23, 1998 at 9:04 pm
Sep 26, 1998 at 10:03 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 158 |
posts | 678 |
users | 78 |
website | postgresql.org... |
irc | #postgresql |
78 users for September 1998
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)