dropping foreign key

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: dropping foreign key
Date: 2001-10-23 21:58:50
Message-ID: 3BD5E81A.9010406@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2001-10-23 22:14:39 Re: can't update 'c:\windows'
Previous Message Andre Schnabel 2001-10-23 20:17:59 Re: Diferent databases on same query...