Re: dropping foreign keys

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