What's the best way to modify a foreign key constraint?
I need to change a foreign key from ON DELETE NO ACTION to ON DELETE
CASCADE. Should I just drop the constraint and re-add it? For example:
ALTER TABLE foo DROP CONSTRAINT foo_bar_id_fkey;
ALTER TABLE foo ADD FOREIGN KEY (foo_bar_id_fkey) REFERENCES bar(id) ON
DELETE CASCADE;
Is there a more compact way to do this, perhaps with a single ALTER
TABLE command?
Thanks!
Marc