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

Bruce Momjian wrote:
> 
> Any comments on this?
> 
> >
> > Following is I believe evidence of a pretty bad bug in postgres. This is
> > the 990329 snapshot.       ^^^^^^
Snapshot's too old?

> > 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!

I can't reproduce this in current...

Vadim