In terms of making constraints more declarative, I think it would be neat to
add an extra field to pg_relcheck that is a foreign key (or null) into the
pg_attribute table.
That way, it would be possible to recover column CHECK constraints. If the
field is NULL, you'd assume it was a table CHECK constraint...
Theoretically, it would mean that less information is 'lost' after the table
creation.
Chris