Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Gould
Subject Re: ALTER TABLE ... DROP CONSTRAINT
Date
Msg-id 20030730160709.22226.qmail@web13402.mail.yahoo.com
Whole thread Raw
In response to ALTER TABLE ... DROP CONSTRAINT  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
List pgsql-general
Tree view 
--- Elielson Fontanezi <ElielsonF@prodam.sp.gov.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

pgsql-general by date:

Previous
From: Elielson Fontanezi
Date:
Subject: ALTER TABLE ... DROP CONSTRAINT
Next
From: "Guillaume Houssay"
Date:
Subject: Alter table