ON DELETE CASCADE PROBLEM - Mailing list pgsql-general

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