Richard Broersma Jr wrote:
Sure there is, you can preform multiple alterations in one statement:
ALTER TABLE foo DROP CONSTRAINT foo_bar_id_fkey,
ADD CONSTRAINT foo_bar_id_fkey
FOREIGN KEY (bar_fkey)
REFERENCES bar (id)
ON DELETE C
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_fk
Whoops,
ALTER TABLE foo ADD FOREIGN KEY (foo_bar_id_fkey) REFERENCES bar(id) ON
DELETE CASCADE;
should be
ALTER TABLE foo ADD FOREIGN KEY (bar_id) REFERENCES bar(id) ON DELETE
CASCADE;
Sorry!
Marc
---(end of broadcast)---
T
