| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dropping foreign keys |
| Date: | 2001-12-14 05:59:23 |
| Message-ID: | 3C19953B.3070605@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)selectacast(dot)net
Increase signal to noise ratio. http://xis.xtenit.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-12-14 06:35:00 | Re: dropping foreign keys |
| Previous Message | Andrew Snow | 2001-12-14 05:26:53 | Re: storing intermediate results from recursive plpgsql |