Thread: altering column constraints

altering column constraints

From
Kyle
Date:
Is it possible to alter a column check constraint without a
dump/reload?  Now that I have RI working, it is a little more tricky to
dump/reload a single table because you lose reference triggers.  So I'm
not sure how to change a column constraint without dumping/reloading the
entire database.

I looked at editing pg_relcheck directly.  I don't know if that is legal
or not, but the rcbin column worries me as I'm not sure how/when this
gets derived from the rcsrc column.  Anyone know if this is possible to
do (even if it requires some poking around)?


Attachment