From: Kristis Makris <kristis.makris@datasoft.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@postgresql.org
Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Date: 11 Jul 2001 09:17:27 -0700
Message-ID: <200107111617.f6BGHSa45693@postgresql.org> (raw)
In-Reply-To: <21997.994867629@sss.pgh.pa.us>
References: <200107110034.f6B0YX879575@hub.org>
<18395.994864895@sss.pgh.pa.us>
<200107111604.f6BG4xJ21783@sss.pgh.pa.us>
<21997.994867629@sss.pgh.pa.us>
On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
> 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?
I suspected that, grep'ed all my sql source for "pg_shadow" and the only
place where I use the pg_shadow table is on the "UPDATE pg_shadow"
statement. So if I haven't referenced the pg_shadow table, is there any
other way I might have implicitly created a trigger for it?
-Kristis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kristis.makris@datasoft.com, tgl@sss.pgh.pa.us, pgsql-bugs@postgresql.org
Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
In-Reply-To: <200107111617.f6BGHSa45693@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox