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 90A38D1C4D5
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 30 Jul 2003 19:25:19 +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 81257-06
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 30 Jul 2003 16:24:17 -0300 (ADT)
Received: from trade-india.com (ns5.trade-india.com [66.234.10.13])
	by svr1.postgresql.org (Postfix) with SMTP id 746B1D1C995
	for <pgsql-general@postgresql.org>;
	Wed, 30 Jul 2003 16:25:12 -0300 (ADT)
Received: (qmail 11035 invoked by uid 0); 30 Jul 2003 19:24:38 -0000
Received: from mallah@trade-india.com by ns5.trade-india.com by uid 502 with
	qmail-scanner-1.15 (uvscan: v4.1.60/v4171.  Clear:.
	Processed in 0.944065 secs); 30 Jul 2003 19:24:38 -0000
Received: from unknown (HELO trade-india.com) (203.145.130.142)
	by ns5.trade-india.com with SMTP; 30 Jul 2003 19:24:37 -0000
Message-ID: <3F281B9E.1050804@trade-india.com>
Date: Thu, 31 Jul 2003 00:55:18 +0530
From: Rajesh Kumar Mallah <mallah@trade-india.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030701
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: pgsql-general <pgsql-general@postgresql.org>,
	pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
References: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
In-Reply-To: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/1486
X-Sequence-Number: 46339


if the constraint are named $1 $2 etc you will need to quote them eg

ALTER TABLE xyz DROP CONSTRAINT "$1" ;

in some version you may require

ALTER TABLE xyz DROP CONSTRAINT "$1"  RESTRICT;

What is ur version btw?

try to post the table structure also.

regds mallah.

Elielson Fontanezi 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)
>
>                                    >\\\!/<     55 11 5080 9283
>                                    !_"""_!     Elielson Fontanezi
>                                    (O) (o)     PRODAM - Technical 
> Support Analyst
> -------------------------------oOOO--(_)--OOOo-----------------------------------
>      Success usually comes to those who are too busy to be looking for it.
>                             oooo0          0oooo
> ---------------------------(    )----------(    
> )--------------------------------
>                             \  (            )  /
>                              \_/            \_/
>
>