Re: How to drop an trigger - Mailing list pgsql-sql

From Frank Joerdens
Subject Re: How to drop an trigger
Date
Msg-id 20010308170629.A16771@rakete.joerdens.de
Whole thread Raw
In response to How to drop an trigger  (Frank Joerdens <frank@joerdens.de>)
Responses Re: Re: How to drop an trigger  (Frank Joerdens <frank@joerdens.de>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: No Documentation for to_char(INTERVAL, mask)
Next
From: Najm Hashmi
Date:
Subject: Re: quotes in pl/pgsql 0n variable type text or varchar