Thread: Drop NOT NULL constraint !!!

 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

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/

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