Re: dropping foreign keys

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

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

Stephan Szabo wrote:

> 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.
>
>


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://xis.xtenit.com