Re: How to drop an <unnamed> trigger

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to drop an <unnamed> trigger
Date: 2001-03-08 16:06:29
Message-ID: 20010308170629.A16771@rakete.joerdens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Boulat Khakimov 2001-03-08 16:44:04 Writing SQL functions in Postgres
Previous Message Josh Berkus 2001-03-08 15:59:41 Re: No Documentation for to_char(INTERVAL, mask)