Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6BG7Ia40733 for ; Wed, 11 Jul 2001 12:07:18 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f6BG7AJ22000; Wed, 11 Jul 2001 12:07:10 -0400 (EDT) To: Kristis Makris cc: pgsql-bugs@postgresql.org Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found In-reply-to: <200107111604.f6BG4xJ21783@sss.pgh.pa.us> References: <200107110034.f6B0YX879575@hub.org> <18395.994864895@sss.pgh.pa.us> <200107111604.f6BG4xJ21783@sss.pgh.pa.us> Comments: In-reply-to Kristis Makris message dated "11 Jul 2001 09:04:45 -0700" Date: Wed, 11 Jul 2001 12:07:09 -0400 Message-ID: <21997.994867629@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200107/44 X-Sequence-Number: 1822 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? regards, tom lane