Stuart Bishop wrote: > > > On Mon, Oct 5, 2009 at 11:00 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote: > >Stuart Bishop wrote: > >>On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys > >><dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > > > >>> A similar issue was discussed just recently here: > >>> http://archives.postgresql.org/pgsql-general/2009-09/msg01219.php > >>> > >>> That issue involved cursors though (and a serializable isolation level, but > >>> you have that). Do you have any triggers that use cursors on the table that > >>> the update fails for? > >> > >>There is a trigger on that table, and it is certainly the culprit as > >>can be seen here (different table, same trigger): > > > >I don't think the committed patch touches anything involved in what > >you're testing, but if you could grab CVS tip from the 8.4 branch (or > >the snapshot from ftp.postgresql.org:/pub/snapshot/stable/8.4 ) and give > >it a try, that'd be great. > > I trigger the same error with a freshly built snapshot. mmkay. So, any luck in constructing a test case? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general