[BUGS] Bug in move 0

2000-03-13 Thread jutso
= POSTGRESQL BUG REPORT TEMPLATE = Your name : Jutso Hung Your email address : [EMAIL PROTECTED] System Configu

Re: [BUGS] PostgreSQL bug report

2000-03-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > INSERT INTO test2 > SELECT 1,1 UNION > SELECT 1,1; > field1|field2 > --+-- > 1| 2 > (this output is wrong as field2 should be 3 after the second and third > insert) "Second and third insert"? SELECT 1,1 UNION SELECT 1,1 produces only a single tupl

Re: [BUGS] select for update breaks database

2000-03-13 Thread Peter Eisentraut
Cary O'Brien writes: > Executing a "select ... for update" corrupts index files. I can confirm that in 6.5.2. *shudder* But 7.0.0 looks fine. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Swed

Re: [BUGS] select for update breaks database

2000-03-13 Thread Bruce Momjian
[Charset ISO-8859-1 unsupported, filtering to ASCII...] > Cary O'Brien writes: > > > Executing a "select ... for update" corrupts index files. > > I can confirm that in 6.5.2. *shudder* But 7.0.0 looks fine. Well, that's good to know that it is fixed in 7.0. -- Bruce Momjian