[GENERAL] Undocumented Postgres error: failed to fetch old tuple for AFTER trigger

2008-06-26 Thread Robert James
I'm running a very large series of commands - mainly DDL but some DML as well - in a large transaction. I get the following error, which doesn't seem to be documented: ERROR: failed to fetch old tuple for AFTER trigger : COMMIT There are no triggers that I'm aware of. I've gotten this error

Re: [GENERAL] Undocumented Postgres error: failed to fetch old tuple for AFTER trigger

2008-06-26 Thread Lennin Caro
the table o tables have triggers? try to useĀ  COMMIT --- On Thu, 6/26/08, Robert James [EMAIL PROTECTED] wrote: From: Robert James [EMAIL PROTECTED] Subject: [GENERAL] Undocumented Postgres error: failed to fetch old tuple for AFTER trigger To: Postgres General pgsql-general@postgresql.org Date

Re: [GENERAL] Undocumented Postgres error: failed to fetch old tuple for AFTER trigger

2008-06-26 Thread Tom Lane
Robert James [EMAIL PROTECTED] writes: ERROR: failed to fetch old tuple for AFTER trigger I'm running Postgres 8.2.1 on Windows XP. I seem to remember a bug with this symptom; so your first move ought to be to update to 8.2.latest. If you can still reproduce it afterwards, please send a test