| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE ... DROP CONSTRAINT |
| Date: | 2003-07-30 16:21:20 |
| Message-ID: | 1059582079.27770.38.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
I think you can do some constraints in 7.2, but 7.3 will allow dropping
them all in that fashion.
On Wed, 2003-07-30 at 11:52, Elielson Fontanezi wrote:
> 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
> ---------------------------( )----------(
> )--------------------------------
> \ ( ) /
> \_/ \_/
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Freddy Menjívar M. | 2003-07-30 16:24:54 | Re: ALTER TABLE...DROP CONSTRAINT |
| Previous Message | Guillaume Houssay | 2003-07-30 16:21:17 | Alter table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chad Thompson | 2003-07-30 16:25:39 | Re: [SQL] ALTER TABLE ... DROP CONSTRAINT |
| Previous Message | Andrew Gould | 2003-07-30 16:07:09 | Re: ALTER TABLE ... DROP CONSTRAINT |