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


Mon, 27 Nov 2000 11:54:38 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
pg_relcheck