Stephan Szabo wrote:
> 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
I tried both table names, and in both cases I got :
drop trigger RI_ConstraintTrigger_569229 on utable;
ERROR: DropTrigger: there is no trigger ri_constrainttrigger_569229 on relation utable
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://xis.xtenit.com