Jeroen Ruigrok/asmodai <[EMAIL PROTECTED]> writes: > can someone add: > Add an ALTER TABLE MODIFY CONSTRAINT > item to the todo list?
Why? For a constraint, it's not obvious what this would do for you that dropping and re-adding the constraint wouldn't do. In the places where we support CREATE OR REPLACE, it's because it's important to maintain continuity of the object's identity, but I don't see any need for that with respect to check constraints. BTW, getting something put on the todo list doesn't mean anyone's going to step up to the plate and do it ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster