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)?