| 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: | Whole Thread | Raw Message | 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
| 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 |