From: Ludwig Lim <lud_nowhere_man@yahoo.com>
To: mallah@trade-india.com
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Drop NOT NULL constraint !!!
Date: Thu, 21 Nov 2002 03:01:22 -0800 (PST)
Message-ID: <20021121110122.13906.qmail@web80304.mail.yahoo.com> (raw)
In-Reply-To: <50448.203.145.129.4.1037819878.squirrel@mail.trade-india.com>
--- mallah@trade-india.com wrote:
>
> do a \d tablename
>
> for the name of the contraint.
> say its $1
> the do
>
> psql> alter table <tablename> drop contstraint "$1"
> RESTRICT;
>
I alter a table with by adding a foriegn key
constraint.
ALTER TABLE sc_city ADD CONSTRAINT cons_fkey
FOREIGN KEY state_cd REFERENCE sc_state(state_cd);
After altering the table I executed
"\d <table name>" show the following:
Triggers: RI_ConstraintTrigger_56743429
I'm surprised that name of constraint doesn't appear
even though I explictly name it. Is there a way to
show the name of the constraint?
Should I do :
ALTER TABLE sc_city DROP CONSTRAINT
RI_ConstraintTrigger+5674329 RESTRICT ?
Thank you very much,
ludwig
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.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: lud_nowhere_man@yahoo.com, mallah@trade-india.com
Subject: Re: Drop NOT NULL constraint !!!
In-Reply-To: <20021121110122.13906.qmail@web80304.mail.yahoo.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