From: Chad Thompson <chad@weblinkservices.com>
To: pgsql-general <pgsql-general@postgresql.org>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
Date: Wed, 30 Jul 2003 10:25:39 -0600
Message-ID: <001b01c356b7$3791c5d0$32021aac@chad> (raw)
References: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
Hi all!
Who can tell me what postgres version supports ALTER TABLE... DROP CONSTRAINT without
the need of droping the table to remove a simple coinstraint. (link)
>\\\!/< 55 11 5080 9283
!_"""_! Elielson Fontanezi
(O) (o) PRODAM - Technical Support Analyst
-------------------------------oOOO--(_)--OOOo-----------------------------------
Success usually comes to those who are too busy to be looking for it.
oooo0 0oooo
---------------------------( )----------( )--------------------------------
\ ( ) /
\_/ \_/
7.3 supports the drop constraint. The only exception begin if you upgraded your database. It keeps the existing trigger like constraints if youve moved from 7.1 or 7.2. But these triggers can be dropped as well.
HTH
Chad
P.S. Great signature! :-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chad@weblinkservices.com, pgsql-general@postgresql.org
Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
In-Reply-To: <001b01c356b7$3791c5d0$32021aac@chad>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox