Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Date
Msg-id 21997.994867629@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found  (pgsql-bugs@postgresql.org)
Responses Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found  (Kristis Makris <kristis.makris@datasoft.com>)
List pgsql-bugs
Kristis Makris <kristis.makris@datasoft.com> writes:
> On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote:
>> Hmm, are you trying to create triggers on pg_shadow?  It's hard to see
>> how that message could come from an "UPDATE pg_shadow" otherwise.

> I'm not trying to explicitly create triggers on pg_shadow. None of the
> triggers/tables/sequences/functions I've created so far try to reference
> the pg_shadow in any way, so I don't *believe* (but I could be wrong)
> that I've even implicitly created a trigger on pg_shadow;

Maybe you made a table with a foreign key reference to pg_shadow?

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: ecpg: INITALLY DEFERRED translated into intially deferrable
Next
From: Tom Lane
Date:
Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found