Re: [HACKERS] Pretty bad bug in Postgres.

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