| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: dropping foreign key |
| Date: | 2001-10-24 21:12:31 |
| Message-ID: | 3BD72EBF.5020709@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Can I just set tgenabled to false?
Stephan Szabo wrote:
> On Tue, 23 Oct 2001, Joseph Shraibman wrote:
>
>
>>I have to drop a froeign key from one of my tables. The problem is that I have another
>>table that has a foreign key on the first one, so I can't do the select to temp-table
>>thing and move it back.
>>
>>Is there any way I can remove it by mucking with pg's internal tables?
>>
>
> Yeah. All you should need to do is remove the three triggers that
> were created for the constraint (1 on the fk table, 2 on the pk table).
> You can find them in pg_trigger and you'll need to double quote the
> names for the drop trigger statements because they're mixed case.
>
>
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-10-24 21:55:05 | Re: dropping foreign key |
| Previous Message | Suyam | 2001-10-24 19:58:21 | Question regarding Function & Return table |