Search Discussions
-
Does SQL92 syntax allow dropping several columns, i.e. ALTER TABLE mytable DROP COLUMN col1,col5,col6; If it does, it would be very desirable to implement it to avoid the need for vacuum between each ...
Hannu Krosing
Feb 27, 2000 at 5:58 pm
Oct 10, 2000 at 12:01 pm -
Having been away for some time I'm very anxious to see that there's a 7.0 release coming very soon. I extracted the TODO list from the CVS (latest update February 9). The only really really big issue ...
Kaare Rasmussen
Feb 21, 2000 at 8:25 pm
Mar 8, 2000 at 5:39 am -
We have discussed in the past the need for the optimizer to take LIMIT into account when choosing plans. Currently, since planning is done on the basis of total plan cost for retrieving all tuples, ...
Tom Lane
Feb 10, 2000 at 4:48 pm
Feb 16, 2000 at 11:46 pm -
Yes, but how do you keep that accurate? If I add indexes, then drop them, does relhasindex go to false. Could you do that for relhassubclass? -- Bruce Momjian | http://www.op.net/~candle ...
Bruce Momjian
Feb 3, 2000 at 12:21 pm
Feb 5, 2000 at 2:07 am -
47
TODO item
In the TODO file: * -Allow transaction commits with rollback with no-fsync performance [fsync](Vadim) Has this been done in current? I see almost no performance improvement on copying data into a ...Tatsuo Ishii
Feb 5, 2000 at 10:33 am
Feb 10, 2000 at 12:27 am -
30
New Globe
I have the new developer's globe online. Please check your BIOs and let me know if there's anything that needs correcting. For those without pictures, don't be so shy. Submit a picture - if you need ...Vince Vielhaber
Feb 7, 2000 at 12:12 pm
Jun 9, 2000 at 12:31 pm -
Hi, as I said, I tring implement PREPARE / EXECUTE command for user a controllable query cache (in TODO: Cache most recent query plan(s)). I have implement first usable version now (I know that it is ...
Karel Zak
Feb 22, 2000 at 3:48 pm
Mar 1, 2000 at 9:35 am -
I've just committed changes to "reunify" the date/time types. "timestamp" and "interval" are now the two primary date/time types for users. Also, I've changed the default date style to "ISO" (not ...
Thomas Lockhart
Feb 16, 2000 at 5:33 pm
Feb 19, 2000 at 10:25 pm -
I'm comparing v6.5.2 against v7.0 and I see now: UPDATEs and INSERTs are faster in v7.0 than v5.6.2 but SELECTs are slow, specially: SELECT ... UNION (is 3 / 4 times slow) and SELECT...HAVING, this ...
José Soares
Feb 28, 2000 at 2:11 pm
Mar 4, 2000 at 12:43 am -
23
bug in 7.0
This is probably related to Lockhart's changes to allow not null/not deferrable to work (foreign key stuff). I'm sympathetic, I looked at gram.y for awhile myself trying to figure a way out of the ...Don Baccus
Feb 28, 2000 at 3:24 pm
Mar 1, 2000 at 8:24 pm -
I've got most of the regression tests running, but one of the rules tests has uncovered a problem in my code, at least for a query involving a merge join. Could someone run a "-d 99" query using the ...
Thomas Lockhart
Feb 11, 2000 at 6:03 am
Feb 18, 2000 at 5:06 am -
Hi, there was discussion about readding the lztext type for internal use in pg_rewrite for 7.0, then remove it again once we have TOAST. Was because significant growth of the rule plan strings due to ...
Jan Wieck
Feb 25, 2000 at 8:48 pm
Feb 27, 2000 at 1:33 am -
Well, don't I look stupid here. Once upon a time I recall to have fixed exactly this issue, apparently it snuck back in. If you run psql in non-interactive mode the psqlrc file shouldn't be read at ...
Peter Eisentraut
Feb 24, 2000 at 12:47 pm
Feb 25, 2000 at 1:07 am -
Um, you're right of course --- those are lexer not parser datastructures you're poking into. Sorry for my confusion. We do in fact work with non-bison parser generators, or did last time I tried it ...
Tom Lane
Feb 21, 2000 at 1:03 am
Jun 9, 2000 at 12:40 pm -
When will we release 7.0? I just checked and found that I'm way behind my schedule. The parser is in sync, but there are quite some open bugs. So hopefully there is either enough time left or someone ...
Michael Meskes
Feb 22, 2000 at 7:54 pm
Feb 23, 2000 at 9:10 am -
Hi, For PostgreSQL We tend to use the Phrase "Most Advanced Open Source RDBMS" alot. Will this statement still hold true when/if Inprise becomes open source ? Jeff ...
"Jeff MacDonald
Feb 15, 2000 at 2:51 pm
Feb 18, 2000 at 1:51 pm -
libpq should be back to normal (printing and all). Sorry once again for the mess. The psql quoting issue should be fixed as well. As is usual for hand-crafted parsers, there's probably something I ...
Peter Eisentraut
Feb 7, 2000 at 11:07 pm
Feb 11, 2000 at 6:47 am -
Hi, The following phenomenon was reported to pgsql-jp(ML in Japan). rest=# select -1234567890.1234567; ERROR: Unable to convert left operator '-' from type 'unknown' -1234567890.1234567 is treated as ...
Hiroshi Inoue
Feb 21, 2000 at 7:00 am
Feb 26, 2000 at 11:46 pm -
Attached is a patch for the ONLY inheritance functionality... *) It includes a SET compatibility mode. *) The overhead for non-inheritance has been cut down to 30 microseconds (on a pc). *) It needs ...
Chris
Feb 5, 2000 at 3:36 am
Feb 7, 2000 at 1:13 am -
IMHO, the syntax for create user is a hell and a half. Adding more keywords in the current fashion is a dead end. (Note: you have to remember the order in which the user "features" have to be ...
Peter Eisentraut
Feb 28, 2000 at 11:17 pm
Mar 6, 2000 at 6:38 pm -
I've since seen the article in the latest issue of PCWeek. The article was not at all clear on the *specific* features which would disqualify Postgres from having SQL92 entry level compliance (for ...
Thomas Lockhart
Feb 17, 2000 at 6:22 am
Mar 2, 2000 at 2:40 pm -
Well, LZTEXT is there again, and pg_rewrite uses it for action and qual strings. This is what it tells: pgsql=# select rulename, length(ev_action), octet_length(ev_action) pgsql-# from pg_rewrite; ...
Jan Wieck
Feb 27, 2000 at 12:15 pm
Feb 28, 2000 at 7:53 am -
Hi, what's happen with network_ops in current CVS ? I just synced sources and couldn't load dump from 6.5.3 - problem occures on CREATE INDEX "face_key" on "face" using btree ( "eid" "int4_ops", "ip" ...
Oleg Bartunov
Feb 7, 2000 at 8:34 pm
Feb 9, 2000 at 12:21 am -
We've already seen how column alias were breaking pg_dump's ability to restore views unless a table alias were created, fixed now thanks to Tom's hack. Here's an observation that's not really a bug ...
Don Baccus
Feb 23, 2000 at 4:20 pm
Feb 29, 2000 at 3:55 pm -
Just downloaded a completely fresh cvs copy. When I do initdb... This user will own all the files and must also own the server process. Creating Postgres database system directory ...
Chris
Feb 1, 2000 at 12:14 pm
Feb 2, 2000 at 4:09 am -
I am afraid of lots of user complaints, even if we had not already used TEMP. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | ...
Bruce Momjian
Feb 29, 2000 at 5:59 am
Mar 1, 2000 at 6:35 am -
12
TRANSACTIONS
Hi all, The transactions should be the way to distinguish a relational database from others no-relational databases, (MySQL is the right example). We are very proud of PostgreSQL transactions but ...José Soares
Feb 22, 2000 at 11:48 am
Feb 25, 2000 at 7:27 pm -
Why isn't this casted automatically? Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: ...
Michael Meskes
Feb 16, 2000 at 11:51 am
Feb 19, 2000 at 2:11 pm -
Hi I'm running postgres v6.5.3. I need to make calls to the functions in libpq in my code. For this I need the files - libpq.lib/libpq.lib.dll/libpqdll.lib. When I run 'nmake /f win32.mak' in the src ...
Rini Dutta
Feb 10, 2000 at 12:02 am
Feb 11, 2000 at 3:14 pm -
The following used to work in 6.5, works in Oracle, and is very useful: donb=# create table foo(c varchar); CREATE donb=# insert into foo values('abc'); INSERT 72649 1 donb=# select distinct c from ...
Don Baccus
Feb 7, 2000 at 3:06 am
Feb 7, 2000 at 6:53 pm -
(This is mostly directed at Bruce, but anyone else who's looked at the planner/optimizer is welcome to chime in.) On the way to implementing estimates of WHERE-clause costs, I was forced to notice ...
Tom Lane
Feb 6, 2000 at 2:22 am
Feb 6, 2000 at 11:27 pm -
We were having some trouble doing updates to our database, a lot of our database sort of works like this: dbfunc(data) somedatatype *data; { somedatatype *existing_row; existing_row = ...
Alfred Perlstein
Feb 3, 2000 at 10:28 pm
Feb 4, 2000 at 10:08 pm -
pqbool is removed from libpq-fe.h. Couldn't compile interfaces/perl5 now. In addition,this seems to change external interface of PQprint(). Is it OK ? Regards. Hiroshi Inoue Inoue@tpf.co.jp
Hiroshi Inoue
Feb 2, 2000 at 2:25 am
Feb 2, 2000 at 8:06 pm -
subscribe
J.j.geel
Feb 21, 2000 at 2:50 pm
Feb 28, 2000 at 2:34 pm -
Is it possible to define a function in language 'C' that needs more libraries to work? I've got a small example of a function that works like a charm when run against from a binary. However if I put ...
Michael Meskes
Feb 15, 2000 at 12:15 pm
Feb 17, 2000 at 7:46 pm -
Peter E. can you look at this? I see simple prompt doing: fputs(prompt, stdout); which I think should be stderr. Peter, can you check on those? -- Bruce Momjian | http://www.op.net/~candle ...
Bruce Momjian
Feb 16, 2000 at 11:37 pm
Feb 17, 2000 at 11:25 am -
Hi there, I've just had a look at the 7.0beta and I've seen your enhancements about LIMIT optimization. Did you read by chance my previous message intitled "Generalized Top Queries on PostgreSQL"? ...
Roberto Cornacchia
Feb 23, 2000 at 5:41 am
Feb 24, 2000 at 9:48 pm -
This is a Call For Hackers: Some time ago, I floated a little discussion on this list about doing some distributed database work with PostgreSQL. The project got back burnered at work, but now has a ...
Ross J. Reedstrom
Feb 7, 2000 at 9:11 pm
Feb 8, 2000 at 3:44 pm -
9
ONLY
Been trying to read the SQL3 draft. My best guess is that this is the appropriate section... Let T be the table identified by <ANSI <table name <ISO <table or query name contained in a <table ...Chris Bitmead
Feb 7, 2000 at 5:25 am
Feb 8, 2000 at 12:00 am -
Hi, looking at all the complications about dealing with segmented files etc., I wonder if it's really worth the efford to add file buffering to the trigger queue. The memory footprint left by ...
Jan Wieck
Feb 8, 2000 at 4:05 pm
Jun 10, 2000 at 10:12 pm -
Here is my list of 7.0 changes. Please let me know of any changes I should make to it. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard ...
Bruce Momjian
Feb 23, 2000 at 8:13 pm
Feb 27, 2000 at 2:56 pm -
MS Access has transactions and Informix (Version 5.00 - 9.20) performs create, drop, alter inside the transaction, same as Oracle and DB2. I am pretty sure that the behavior of the others is the ...
Andreas Zeugswetter
Feb 23, 2000 at 8:27 am
Feb 23, 2000 at 5:03 pm -
I have written a man page for pg_ctl. I will appreciate if someone would give me comments on it including grammatical corrections. -- Tatsuo Ishii NAME pg_ctl - starts/stops/restarts postmaster ...
Tatsuo Ishii
Feb 6, 2000 at 3:46 am
Feb 22, 2000 at 1:42 am -
Hi I have a crash while creating regression database in pararell regression test. Seems it's due to the following change. @@ -2638,7 +2705,14 @@ n- dbname = $3; n- dbpath = $5; #ifdef MULTIBYTE - n- ...
Hiroshi Inoue
Feb 17, 2000 at 12:36 am
Feb 18, 2000 at 2:47 pm -
Are we still 'go' for a beta release the 15th? Before I pull a latenighter RPM building.....it would be nice to have an idea. TIA! -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Lamar Owen
Feb 14, 2000 at 9:19 pm
Feb 16, 2000 at 3:01 am -
Someone mentioned recently that a timezone style of "GMT+0800" was on their FreeBSD machine as an allowed time zone, that its behavior was the same as the usual ISO8601 timezone of "-0800", and that ...
Thomas Lockhart
Feb 6, 2000 at 10:16 pm
Feb 10, 2000 at 6:44 am -
As you surely noticed, the psql -e flag ("echo" modus, if you will) has changed its format (regression tests ring a bell?) in that it echoes the input file verbatim. For the particular case of the ...
Peter Eisentraut
Feb 6, 2000 at 1:06 pm
Feb 7, 2000 at 7:49 pm -
Looking at the example I just cited, it's hard to avoid noticing how much space is being used on purely-decorative field labels. For example, { TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 ...
Tom Lane
Feb 27, 2000 at 10:39 pm
Feb 28, 2000 at 2:40 pm -
Hi everybody, I'm done my tests of PostgreSQL and Interbase. I concentrated on two tests, an OLTP Single Read Test, where we read a single row out of a 200K row indexed table, and the OLTP Read Mix ...
Timothy Dyck
Feb 4, 2000 at 10:53 am
Feb 26, 2000 at 5:35 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 214 |
posts | 1,464 |
users | 110 |
website | postgresql.org... |
irc | #postgresql |
110 users for February 2000
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)