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 disreg
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
dro
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
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"
