Thread: ON DELETE CASCADE PROBLEM

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

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?