| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>, pgsql-hackers(at)hub(dot)org |
| Subject: | Re: [HACKERS] Pretty bad bug in Postgres. |
| Date: | 1999-05-10 16:23:04 |
| Message-ID: | 373707E8.F1EEF164@krs.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-05-10 16:26:44 | Re: [HACKERS] create view as select distinct (fwd) |
| Previous Message | Bruce Momjian | 1999-05-10 16:19:49 | Re: [HACKERS] create view as select distinct (fwd) |