Re: drop constraint unnamed?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
Cc: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: drop constraint unnamed?
Date: 2002-10-14 17:24:31
Message-ID: 17186.1034616271@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andy Kriger" <akriger(at)greaterthanone(dot)com> writes:
> How do you drop an unnamed constraint from a table?

Is this a foreign-key constraint? If so, you have to drop the three
triggers that implement it; see the recipe on the
techdocs.postgresql.org site.

(7.3 will have a more reasonable way to drop FK constraints ...)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-14 17:25:54 Re: string concatenation
Previous Message Stephan Szabo 2002-10-14 17:20:02 Re: deferred cascade delete re-check at end of transaction?