Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found

Поиск
Список
Период
Сортировка
Искать
От
Kristis Makris
Тема
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Дата
Msg-id
200107111617.f6BGHSa45693@postgresql.org
Ответ на
Список
Дерево обсуждения
ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found pgsql-bugs@postgresql.org
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Tom Lane <tgl@sss.pgh.pa.us>
Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Kristis Makris <kristis.makris@datasoft.com>
On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote:
> Kristis Makris  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
В списке pgsql-bugs по дате отправления
От: Manoj Nair
Дата:
От: Rocke Robertson
Дата:
FAQ