Re: [GENERAL] Drop Column with Foreign Key Problem

2004-07-03 Thread Thomas Chille
Hi Tom! Thanx again for your fast help. And its helps indeed. You pointed out the problem correct! I could delete these triggers after scanning the system-tables by hand. Unfortunately this can happen in the futrue again and thatswhy i tried applying the adddepend script on a fresh restored db

[GENERAL] Drop Column with Foreign Key Problem

2004-07-01 Thread Thomas Chille (spoon)
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_employee'. I drop this column of the table with cascade in a script: ALTER TABLE public.sd_messaging_parti