Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3ECC99FB613 for ; Thu, 17 May 2007 11:27:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 81141-01 for ; Thu, 17 May 2007 11:27:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from joshua.dreamthought.com (joshua.dreamthought.com [193.201.200.96]) by postgresql.org (Postfix) with ESMTP id 5851C9FB4E0 for ; Thu, 17 May 2007 11:27:22 -0300 (ADT) Received: from rafiq (helo=localhost) by joshua.dreamthought.com with local-esmtp (Exim 4.66 ()) (envelope-from ) id 1Hogz3-000IrH-3H; Thu, 17 May 2007 15:29:37 +0100 Date: Thu, 17 May 2007 15:29:37 +0100 (BST) From: Raf To: Tom Lane cc: pgsql-admin@postgresql.org Subject: Re: Manual trigger removal [WAS] Flushing Postgres Function Cache In-Reply-To: <23514.1179411067@sss.pgh.pa.us> Message-ID: <20070517152714.J69332@joshua.dreamthought.com> References: <20070517092853.R69332@joshua.dreamthought.com> <20070517122322.V69332@joshua.dreamthought.com> <20070517131522.T69332@joshua.dreamthought.com> <20070517135952.F69332@joshua.dreamthought.com> <23181.1179409363@sss.pgh.pa.us> <20070517145059.W69332@joshua.dreamthought.com> <23514.1179411067@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: rafiq@joshua.dreamthought.com X-SA-Exim-Scanned: No (on joshua.dreamthought.com); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/165 X-Sequence-Number: 25485 On Thu, 17 May 2007, Tom Lane wrote: > Raf writes: >> On Thu, 17 May 2007, Tom Lane wrote: >> Even though there were 0 rows associated with the table's oid in >> pg_depend and pg_triggers ? > > Oh, OK, you want zero then. I had misread it to indicate that only one > of four triggers had gone missing. Well, the counter was set at 4. The triggers were sloni related, and I think running Sloni removal may have removed the other triggers without updating the trigger count. Why, I don't know? I was left with the one dangling trigger, which was manually removed and I then updated the counter to represent the state of pg_deps and pg_triggers. Thanks, Raf