Undocumented Postgres error: "failed to fetch old tuple for AFTER trigger"

From: "Robert James" <srobertjames(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Undocumented Postgres error: "failed to fetch old tuple for AFTER trigger"
Date: 2008-06-26 20:28:45
Message-ID: e09785e00806261328q69edbfb2k4cc992ce572bfc8a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 when
running the transaction on two different instances of the database. I also
did a VACUUM FULL, which didn't help.

Breaking down the commands into a series of about 7 smaller transactions
works fine. Each transaction runs totally fine by itself. But, when I run
them all in one giant transaction, I get errors.

I'm running Postgres 8.2.1 on Windows XP. If anyone can help, I'd be very
greatful.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2008-06-26 21:11:21 Re: Probably been asked a hundred times before.
Previous Message Lennin Caro 2008-06-26 20:08:21 Re: Partial Index Too Literal?