[ADMIN] Dropping Foreign Key without recreating table

I wanted to change a foreign key to be deferrable (db version 7.2.1). During table creation I didn't specify a constraint name for the foreign key. \d shows a trigger RI_ConstraintTrigger_17195, however when I'm trying to alter table mytable drop constraint RI_ConstraintTrigger_17195 restrict I'm

Re: [ADMIN] Dropping Foreign Key without recreating table

since name of constrauint is in mixed cased u must double quote it in command. below will work. psql alter table mytable drop constraint RI_ConstraintTrigger_17195 restrict ; I wanted to change a foreign key to be deferrable (db version 7.2.1). During table creation I didn't specify a

Re: [ADMIN] Dropping Foreign Key without recreating table

Oops disregard my prev reply, RI_ConstraintTrigger_17195 is a trigger not contraint so u must in 7.2.1 do DROP TRIGGER RI_ConstraintTrigger_17195 on mytable ; in 7.3 foreign key constraints on tables have name. so you need not drop underlying triggers like in 721 but can use command to drop

Re: [ADMIN] Dropping Foreign Key without recreating table

Thanks Mallah, I didn't realize the name of the trigger is in mixed case. However, I had to drop another 2 triggers on the referenced table. So it looks for me, a foreign key uses 3 triggers at all. Looking into pg_trigger, I found them all. Thanks Egon [EMAIL PROTECTED] wrote: Oops