pg_relcheck

Started by Christopher Kings-Lynneabout 25 years ago1 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

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