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(at)selectacast(dot)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(at)selectacast(dot)net
Increase signal to noise ratio. http://xis.xtenit.com