Re: Check constraints on partition parents only? - Mailing list pgsql-hackers

From Nikhil Sontakke
Subject Re: Check constraints on partition parents only?
Date
Msg-id CANgU5Zc5i_TuiM235zB2VZFb0HWGaqGJ02h42ctOkpyzf_pZRw@mail.gmail.com
Whole thread Raw
In response to Re: Check constraints on partition parents only?  (Nikhil Sontakke <nikhil.sontakke@enterprisedb.com>)
Responses Re: Check constraints on partition parents only?
List pgsql-hackers
Hi all,

PFA, patch which implements non-inheritable "ONLY" constraints. This
has been achieved by introducing a new column "conisonly" in
pg_constraint catalog. Specification of 'ONLY' in the ALTER TABLE ADD
CONSTRAINT CHECK command is used to set this new column to true.
Constraints which have this column set to true cannot be inherited by
present and future children ever.

The psql and pg_dump binaries have been modified to account for such
persistent non-inheritable check constraints. This patch also has
documentation changes along with relevant changes to the test cases.
The regression runs pass fine with this patch applied.

Comments and further feedback, if any, appreciated.

Regards,
Nikhils

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [RFC] Common object property boards
Next
From: Robert Haas
Date:
Subject: Re: [RFC] Common object property boards