Hello!
I have a Problem.
A table with a ForeignKeyRef exits. The Name of the field with this FK-Constraint is 'id_employee'
because it is referencing the field 'id_employee' in 'public.sd_empl oyee'. I drop this column of the
table with cascade in a script:
ALTER TABLE public.sd_messa ging_participan t DROP COLUMN id_employee CASCADE;
In one script later i try to make an update on the referenced Table:
UPDATE sd_employee SET leave = 1.5;
But it doesent works. I get always this Error:
ERROR: constraint participant_emp loyee: table sd_messaging_pa rticipant does not have an attribute
id_employee
The constraint 'participant_em ployee' should be droped too, due the use of CASCADE, but it seems
that he is alive.
Also explizit dropping the constraint 'participant_em ployee' before dropping the field will not
solve the problem:
ALTER TABLE public.sd_messa ging_participan t DROP CONSTRAINT participant_emp loyee CASCADE;
If i try to drop the constraint after dropping the field, postgres means the constraint is not
existing anymore. But if i try to do the update it produces still this error.
If i dump the DB i can not found the constraint 'participant_em ployee' anymore but 3 triggers
belonging to this constraint are still in the DB:
....
CREATE CONSTRAINT TRIGGER participant_emp loyee
AFTER INSERT OR UPDATE ON sd_messaging_pa rticipant
FROM sd_employee
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ ins" ('participant_e mployee', 'sd_messaging_p articipant',
'sd_employee', 'UNSPECIFIED', 'id_employee', 'id_employee');
....
That is for Insert and there are one for Update and one for Deleting too. I have absolutly no idea
how can this happens and i think i could solve this problem by dropping these 3 Triggers. But i dont
know how is the syntax to drop such triggers?
And know anybody out there how it could happen?
Thanks for your help,
Thomas!
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
