Forum OpenACS Q&A: Adding ON DELETE CASCADE

Collapse
1: Adding ON DELETE CASCADE
Posted by Roberto Mello on 04/18/01 01:19 AM
Anyone know of a way to add ON DELETE CASCADE to a table on PG? Or do
I have to drop the table and recreate it? I am working on the upgrade
script and several of these were added to the portals data model.

Thanks.

Collapse
2: Response to Adding ON DELETE CASCADE (response to 1)
Posted by Don Baccus on 04/18/01 02:01 AM
alter table foo add constraint foo_fk foreign key (foo_key) references  referenced_table;

works but you've probably already got a foreign key on that column without the on delete cascade, right?

You can't drop constraints but I think you can maybe drop the triggers  by hand???

People may be SOL on this one, though.