Re: dropping foreign keys - Mailing list pgsql-general

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

> What is the fktable and pktable?  I tried 'fktable' and 'pktable' and
> neither of them worked.

The table the foreign key is on and the table it references, sorry, I've
gotten used to using that shorthand.

> And should I use the tgconstrname or tgname?  I'm using tgconstrname.

Ah, that'd do it.  You need to use the tgname, tgconstrname was the name
given to the actual constraint, but the name for the trigger is different.
(In 7.2 if you were using drop constraint, you'd want to use
tgconstrname).



pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: dropping foreign keys
Next
From: Tom Lane
Date:
Subject: Re: Working on "SELECT * WHERE numeric_col = 2001.2" problem?