Re: dropping foreign keys - Mailing list pgsql-general

From Stephan Szabo
Subject Re: dropping foreign keys
Date
Msg-id 20011213112518.O2574-100000@megazone23.bigpanda.com
Whole thread Raw
In response to dropping foreign keys  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
On Thu, 13 Dec 2001 jks@selectacast.net wrote:

> I tried that, but it didn't work.  I need to drop trigger <name> on
> <table>.  I got the name from the pg_triggers table, but apparently they
> are not associated with any table.

Two should be associated with the pktable and one with the fktable.  I've
done the drop trigger thing in the past, so unless someone's changed
something it should work.  The table names can be grabbed out of the
args, I think generally the first trigger is the one on the fktable
and the other two are the pktable ones.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Can I call unix/linux commands within plsql?
Next
From: "Robert B. Easter"
Date:
Subject: Re: How to increase shared mem for PostgreSQL on FreeBSD