| From: | "Chad Thompson" <chad(at)weblinkservices(dot)com> |
|---|---|
| To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] ALTER TABLE ... DROP CONSTRAINT |
| Date: | 2003-07-30 16:25:39 |
| Message-ID: | 001b01c356b7$3791c5d0$32021aac@chad |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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! :-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-07-30 16:45:29 | Re: Diff between contrib/dbmirror and rserv |
| Previous Message | Freddy Menjívar M. | 2003-07-30 16:24:54 | Re: ALTER TABLE...DROP CONSTRAINT |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Weaver | 2003-07-30 16:45:34 | Re: [SQL] ALTER TABLE ... DROP CONSTRAINT |
| Previous Message | Rod Taylor | 2003-07-30 16:21:20 | Re: ALTER TABLE ... DROP CONSTRAINT |