pg_relcheck - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject pg_relcheck
Date
Msg-id NEBBIOAJBMEENKACLNPCCEJDCCAA.chriskl@familyhealth.com.au
Whole thread Raw
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Indexing for geographic objects?
Next
From: Tom Lane
Date:
Subject: Re: Initdb not running on beos