Received: from rakete.joerdens.de ([62.104.116.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f28G6Yx47578 for ; Thu, 8 Mar 2001 11:06:34 -0500 (EST) (envelope-from frank@rakete.joerdens.de) Received: (from frank@localhost) by rakete.joerdens.de (8.9.3/8.9.3) id RAA16854 for pgsql-sql@postgresql.org; Thu, 8 Mar 2001 17:06:29 +0100 Date: Thu, 8 Mar 2001 17:06:29 +0100 From: Frank Joerdens To: pgsql-sql@postgresql.org Subject: Re: How to drop an trigger Message-ID: <20010308170629.A16771@rakete.joerdens.de> References: <20010308164246.A16533@rakete.joerdens.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.1.2i In-Reply-To: <20010308164246.A16533@rakete.joerdens.de>; from frank@rakete.joerdens.de on Thu, Mar 08, 2001 at 04:42:46PM +0100 X-Subliminal-Message: Use Linux! Use Linux! X-Archive-Number: 200103/176 X-Sequence-Number: 1829 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? Regards, Frank