Re: BUG #5798: Some weird error with pl/pgsql procedure - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5798: Some weird error with pl/pgsql procedure
Date
Msg-id 28343.1308063327@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5798: Some weird error with pl/pgsql procedure  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-bugs
Merlin Moncure <mmoncure@gmail.com> writes:
> I bumped into the 'virtual tuple' error on 9.0.3 on a completely
> unrelated query:

> create table foo(a int, b int);
> insert into foo select 1, 1 where not exists (select 1 from foo where
> a = 1 for update);

> 9.0.4 got rid of the error, but as there are no triggers or anything
> like that on the foo so I thought I'd post my findings here in case
> anyone else bumped into it.

I think most likely this has to do with commit
d5478c3391f8f1a243abbc3d9253aac3d6d3538e, and is unrelated (except
in the error message) to that trigger issue.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: BUG #5798: Some weird error with pl/pgsql procedure
Next
From: "Marc Mamin"
Date:
Subject: BUG #6057: regexp_replace & back references