Skip site navigation (1) Skip section navigation (2)

pg_relcheck

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Pgsql-Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_relcheck
Date: 2000-11-27 03:54:38
Message-ID: NEBBIOAJBMEENKACLNPCCEJDCCAA.chriskl@familyhealth.com.au (view raw or flat)
Thread:
Lists: 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

Next:From: Tom LaneDate: 2000-11-27 05:32:58
Subject: Re: Initdb not running on beos
Previous:From: Tom LaneDate: 2000-11-27 03:32:41
Subject: Re: [HACKERS] Indexing for geographic objects?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group