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.
