Re: [HACKERS] Pretty bad bug in Postgres. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Pretty bad bug in Postgres.
Date
Msg-id 25974.928795957@sss.pgh.pa.us
Whole thread Raw
List pgsql-hackers
Chris Bitmead <chris.bitmead@bigfoot.com> writes:
>> Following is I believe evidence of a pretty bad bug in postgres. This is
>> the 990329 snapshot.

>> httpd=> insert into category(name, image, parent) SELECT 'boo', 'boo',
>> oid FROM category* where name = 'foo';
>> INSERT 158370 1
>> httpd=> select * from category;
>> name    |image|url|parent
>> --------+-----+---+------
>> foo     |foo  |   |     0
>> bar     |bar  |   |158321
>> Products|.gif |   |      
>> (3 rows)

>> Ok, what's going on here. The 'boo' record did not appear!

Chris, I can't reproduce this here anymore --- do you still see it with
current sources?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Oliver Elphick"
Date:
Subject: pg_upgrade loses all data
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_upgrade problem