ON DELETE CASCADE PROBLEM

From: juleni <juleni(at)seznam(dot)cz>
To: Postgres-Mailing-List <pgsql-general(at)postgresql(dot)org>
Subject: ON DELETE CASCADE PROBLEM
Date: 2003-01-28 21:30:14
Message-ID: 17499866328.20030128223014@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)seznam(dot)cz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-01-28 21:31:20 If you are trying to unsubscribe, please READ THIS ...
Previous Message Chris Gamache 2003-01-28 21:27:31 Re: 7.3 LOCK TABLE problem