Re: ALTER TABLE ... DROP CONSTRAINT

--- 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