Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 988F84760FA for ; Thu, 12 Dec 2002 13:17:31 -0500 (EST) Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150]) by postgresql.org (Postfix) with ESMTP id D3488476078 for ; Thu, 12 Dec 2002 13:17:30 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 5063C3F4E; Thu, 12 Dec 2002 13:17:28 -0500 (EST) From: "Dan Langille" To: Tim Perdue Date: Thu, 12 Dec 2002 13:17:28 -0500 MIME-Version: 1.0 Subject: Re: ON DELETE CASCADE Cc: pgsql-sql@postgresql.org Message-ID: <3DF88C68.19620.2AE4A690@localhost> In-reply-to: <3DF8C0D7.7060907@perdue.net> X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/168 X-Sequence-Number: 10756 On 12 Dec 2002 at 11:01, Tim Perdue wrote: > That command works, but now I think I have 2x as many triggers as I > want. How do I get rid of the original triggers? I had to do something similar and documented it at http://www.freebsddiary.org/postgresql-dropping-constraints.php hth -- Dan Langille : http://www.langille.org/