Re: [SQL] ALTER TABLE ... DROP CONSTRAINT - Mailing list pgsql-general

From Chad Thompson
Subject Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
Date
Msg-id 001b01c356b7$3791c5d0$32021aac@chad
Whole thread Raw
In response to ALTER TABLE ... DROP CONSTRAINT  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
List pgsql-general
 
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! :-)

pgsql-general by date:

Previous
From: Robert Partyka
Date:
Subject: How to do?
Next
From: Dave Cramer
Date:
Subject: Re: Integrating the field auto-increment