X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 8EC85D1C4D6
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 30 Jul 2003 16:07:12 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 68258-10
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 30 Jul 2003 13:06:09 -0300 (ADT)
Received: from web13402.mail.yahoo.com (web13402.mail.yahoo.com
	[216.136.175.60])
	by svr1.postgresql.org (Postfix) with SMTP id 2F0E3D1C4D0
	for <pgsql-general@postgresql.org>;
	Wed, 30 Jul 2003 13:07:10 -0300 (ADT)
Message-ID: <20030730160709.22226.qmail@web13402.mail.yahoo.com>
Received: from [24.204.21.207] by web13402.mail.yahoo.com via HTTP;
	Wed, 30 Jul 2003 09:07:09 PDT
Date: Wed, 30 Jul 2003 09:07:09 -0700 (PDT)
From: Andrew Gould <andrewgould@yahoo.com>
Subject: Re: ALTER TABLE ... DROP CONSTRAINT
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>,
	pgsql-general <pgsql-general@postgresql.org>,
	pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/1469
X-Sequence-Number: 46322

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