From: | Kristis Makris <kristis(dot)makris(at)datasoft(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found |
Date: | 2001-07-11 16:17:27 |
Message-ID: | 200107111617.f6BGHSa45693@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-odbc pgsql-sql |
On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
> Kristis Makris <kristis(dot)makris(at)datasoft(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-11 16:40:27 | Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found |
Previous Message | pgsql-bugs | 2001-07-11 16:10:51 | ecpg: INITALLY DEFERRED translated into intially deferrable |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-11 16:40:27 | Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found |
Previous Message | Tom Lane | 2001-07-11 16:07:09 | Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-11 16:40:27 | Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found |
Previous Message | Tom Lane | 2001-07-11 16:07:09 | Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found |