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