Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 88211475E24
	for <pgsql-general@postgresql.org>;
	Wed, 20 Nov 2002 14:18:10 -0500 (EST)
Received: from rtlocal.trade-india.com (mail-relay.trade-india.com
	[203.196.129.235])
	by postgresql.org (Postfix) with SMTP id 14236475B8E
	for <pgsql-general@postgresql.org>;
	Wed, 20 Nov 2002 14:18:07 -0500 (EST)
Received: (qmail 20987 invoked from network); 20 Nov 2002 19:07:15 -0000
Received: from news1.trade-india.com (HELO www.trade-india.com) (130.94.20.27)
	by infocom-236-129-del.trade-india.com with SMTP;
	20 Nov 2002 19:07:15 -0000
Received: (qmail 13166 invoked by uid 99); 20 Nov 2002 19:17:58 -0000
Received: from 203.145.129.4 (proxying for 203.145.130.142)
	(SquirrelMail authenticated user mallah)
	by mail.trade-india.com with HTTP;
	Thu, 21 Nov 2002 00:47:58 +0530 (IST)
Message-ID: <50448.203.145.129.4.1037819878.squirrel@mail.trade-india.com>
Date: Thu, 21 Nov 2002 00:47:58 +0530 (IST)
Subject: Re: [SQL] Drop NOT NULL constraint !!!
From: <mallah@trade-india.com>
To: <rene@ibiz.com.br>
In-Reply-To: <20021120170913.74176c82.rene@ibiz.com.br>
References: <20021120114805.C29739-100000@zoraida.natserv.net>
	<3DDBD5EE.4040804@intransa.com>
	<20021120170913.74176c82.rene@ibiz.com.br>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
Cc: <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>
X-Mailer: SquirrelMail (version 1.2.6)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/1239
X-Sequence-Number: 33659


do a \d tablename

for the name of the contraint.
say its $1
the do

psql> alter table <tablename> drop contstraint "$1" RESTRICT;

> Does anybody could tell me how to drop a constraint on a column where no name was provided to
> the constraint? How does Pg name constraints?
>
> Thanks
> --
> Renê Salomão
> Ibiz Tecnologia -- www.ibiz.com.br
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?
>
> http://archives.postgresql.org



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/