Removing foreign keys

От:

"psql novice" <psql_novice@operamail.com>

Дата:

16 июля 2003 г. в 00:55:36

Hi,

Is it possible to remove foreign keys from a table?
-- 
____________________________________________
http://www.operamail.com
Get OperaMail Premium today - USD 29.99/year


Powered by Outblaze

Re: Removing foreign keys

От:

"psql novice" <psql_novice@operamail.com>

Дата:

16 июля 2003 г. в 01:02:44

Nevermind, found the command :)

----- Original Message -----
From: "psql novice" 
Date: Wed, 16 Jul 2003 04:55:48 +0100
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Removing foreign keys

> Hi,
> 
> Is it possible to remove foreign keys from a table?
> -- 
> ____________________________________________
> http://www.operamail.com
> Get OperaMail Premium today - USD 29.99/year
> 
> 
> Powered by Outblaze
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html

-- 
____________________________________________
http://www.operamail.com
Get OperaMail Premium today - USD 29.99/year


Powered by Outblaze

Re: Removing foreign keys

От:

Jean-Christian Imbeault <jc@mega-bucks.co.jp>

Дата:

16 июля 2003 г. в 11:31:42

psql novice wrote:
> 
> Is it possible to remove foreign keys from a table?

I don't exactly understand what you mean by "remove". Do you mean
dropping the whole column? Setting the field to null? Dropping the
foreign key constraint?

Jean-Christian Imbeault