From: mallah@trade-india.com
To: rene@ibiz.com.br
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Drop NOT NULL constraint !!!
Date: Thu, 21 Nov 2002 00:47:58 +0530 (IST)
Message-ID: <50448.203.145.129.4.1037819878.squirrel@mail.trade-india.com> (raw)
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>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, rene@ibiz.com.br, pgsql-general@postgresql.org
Subject: Re: [SQL] Drop NOT NULL constraint !!!
In-Reply-To: <50448.203.145.129.4.1037819878.squirrel@mail.trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox