Re: drop foreign key - Mailing list pgsql-general

From Stephan Szabo
Subject Re: drop foreign key
Date
Msg-id 20021221203033.X31857-100000@megazone23.bigpanda.com
Whole thread Raw
In response to drop foreign key  ("Madhavi" <madhavi@zoniac.com>)
List pgsql-general
On Fri, 20 Dec 2002, Madhavi wrote:

> Can anybody please tell me how to drop a foreign key associated with a table
> in postgres7.2.3? Please give me the syntax and the query.

In 7.2.3 you'll need to find the three triggers associated with the key
and drop those with drop trigger (doublequoting the name because it's of
mixed case).  Techdocs has some information on foreign keys that will
probably be useful.


pgsql-general by date:

Previous
From: Jan Ploski
Date:
Subject: Re: Unicode database + JDBC driver performance
Next
From: Graham Leggett
Date:
Subject: Re: Unable to format timestamp with time zone; internal