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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
