Re: constraint modification on todo list - Mailing list pgsql-hackers

From Tom Lane
Subject Re: constraint modification on todo list
Date
Msg-id 695.1063053156@sss.pgh.pa.us
Whole thread Raw
In response to constraint modification on todo list  (Jeroen Ruigrok/asmodai <asmodai@wxs.nl>)
Responses Re: constraint modification on todo list  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Jeroen Ruigrok/asmodai <asmodai@wxs.nl> 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql doesn't coerce boolean expressions to boolean
Next
From: ivan
Date:
Subject: pgsql in shared lib