Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6DGVna47920 for ; Fri, 13 Jul 2001 12:31:49 -0400 (EDT) (envelope-from pgsql-bugs-owner@postgresql.org) Received: from datasoft.com (maniac.datasoft.com [63.228.155.187]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6BGHSa45693 for ; Wed, 11 Jul 2001 12:17:28 -0400 (EDT) (envelope-from kristis.makris@datasoft.com) Message-Id: <200107111617.f6BGHSa45693@postgresql.org> Received: (qmail 11849 invoked from network); 11 Jul 2001 16:17:27 -0000 Received: from dsco-user.datasoft.com (HELO leonidas.corp.datasoft.com) (63.228.155.190) by maniac.datasoft.com with SMTP; 11 Jul 2001 16:17:27 -0000 Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found From: Kristis Makris To: Tom Lane Cc: pgsql-bugs@postgresql.org 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> Content-Type: text/plain X-Mailer: Evolution (0.9/+cvs.2001.03.14.20.47 - Preview Release) Date: 11 Jul 2001 09:17:27 -0700 Mime-Version: 1.0 X-Archive-Number: 200107/61 X-Sequence-Number: 1840 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