altering column constraints - Mailing list pgsql-sql

From Kyle
Subject altering column constraints
Date
Msg-id 397C6F21.C434805A@actarg.com
Whole thread Raw
List pgsql-sql
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

pgsql-sql by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: query optimazation & starting postmaster with -B option
Next
From: Kyle
Date:
Subject: TCL updates