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 CASCADE;
Doh! That's perfectly fine, of course.I was wondering if there might be something along the lines of an ALTER CONSTRAINT clause, which could change a specific aspect of a constraint without having to re-specify the whole thing.
Marc
