Re: drop foreign key

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Madhavi <madhavi(at)zoniac(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: drop foreign key
Date: 2002-12-22 04:31:31
Message-ID: 20021221203033.X31857-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Graham Leggett 2002-12-22 13:39:26 Re: Unable to format timestamp with time zone; internal
Previous Message Jan Ploski 2002-12-22 01:16:40 Re: Unicode database + JDBC driver performance