| From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
|---|---|
| To: | Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>, 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:07:09 |
| Message-ID: | 20030730160709.22226.qmail@web13402.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
--- Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
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)
>
> Elielson Fontanezi
> PRODAM - Technical Support
> Analyst
I performed that task yesterday using PostgreSQL
7.3.3:
Alter table mkt drop constraint mkt_pkey;
I don't know if it's supported in earlier versions.
Best regards,
Andrew Gould
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Houssay | 2003-07-30 16:21:17 | Alter table |
| Previous Message | Elielson Fontanezi | 2003-07-30 15:52:09 | ALTER TABLE ... DROP CONSTRAINT |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-07-30 16:21:20 | Re: ALTER TABLE ... DROP CONSTRAINT |
| Previous Message | Elielson Fontanezi | 2003-07-30 15:52:09 | ALTER TABLE ... DROP CONSTRAINT |