--- Elielson Fontanezi <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]