ON DELETE CASCADE PROBLEM

Started by juleniabout 23 years ago2 messagesgeneral
Jump to latest
#1juleni
juleni@seznam.cz

Hello,

I have create an constraint 'udc' using following command:
ALTER TABLE predefined_attr ADD CONSTRAINT udc
FOREIGN KEY (fkid_group_attr) REFERENCES group_attr (id_group_attr)
ON UPDATE CASCADE ON DELETE CASCADE;

After data refreshing is my new created constraint sets to DELETE NO ACTION.
How can I change it to the DELETE CASCADE?

After data refreshing it looks like this:
CONSTRAINT udc FOREIGN KEY (fkid_group_attr) REFERENCES group_attr (id_group_attr)
ON DELETE NO ACTION ON UPDATE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE;

Thanks in advance,
best regards,
julian

mailto:juleni@seznam.cz

#2Stephan Szabo
sszabo@megazone23.bigpanda.com
In reply to: juleni (#1)
Re: ON DELETE CASCADE PROBLEM

On Tue, 28 Jan 2003, juleni wrote:

Hello,

I have create an constraint 'udc' using following command:
ALTER TABLE predefined_attr ADD CONSTRAINT udc
FOREIGN KEY (fkid_group_attr) REFERENCES group_attr (id_group_attr)
ON UPDATE CASCADE ON DELETE CASCADE;

After data refreshing is my new created constraint sets to DELETE NO ACTION.

What do you mean by data refreshing?