Received: from rakete.joerdens.de ([62.104.116.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f28GpVx54962 for ; Thu, 8 Mar 2001 11:51:31 -0500 (EST) (envelope-from frank@rakete.joerdens.de) Received: (from frank@localhost) by rakete.joerdens.de (8.9.3/8.9.3) id RAA17165; Thu, 8 Mar 2001 17:51:26 +0100 Date: Thu, 8 Mar 2001 17:51:26 +0100 From: Frank Joerdens To: Frank Joerdens Cc: pgsql-sql@postgresql.org Subject: Re: Re: How to drop an trigger Message-ID: <20010308175126.A16939@rakete.joerdens.de> References: <20010308164246.A16533@rakete.joerdens.de> <20010308170629.A16771@rakete.joerdens.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.1.2i In-Reply-To: <20010308170629.A16771@rakete.joerdens.de>; from frank@joerdens.de on Thu, Mar 08, 2001 at 05:06:29PM +0100 X-Subliminal-Message: Use Linux! Use Linux! X-Archive-Number: 200103/178 X-Sequence-Number: 1831 On Thu, Mar 08, 2001 at 05:06:29PM +0100, Frank Joerdens wrote: > On Thu, Mar 08, 2001 at 04:42:46PM +0100, Frank Joerdens wrote: > > I've created quite a few foreign key constraints in the database that I > > am currently working on, and now that I've altered the structure and > > dropped a table that had a foreign key reference to a couple of other > > tables, I need to get rid of those foreign keys (they weren't dropped > > automagically with the table), as I get errors on trying to update those > > tables. > > Just an idea: Is it safe to just delete the corresponding row in > pg_trigger? No, it ain't: After deleting the rows corresponding to the offending triggers in pg_trigger, I can't vacuum, or dump. - Frank