Horton
Menu

Re: CHECK NO INHERIT syntax

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Fetter <david@fetter.org>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-07-20T00:05:41Z
Lists: pgsql-hackers 
David Fetter <david@fetter.org> writes:
> On Thu, Jul 19, 2012 at 12:49:37AM +0300, Peter Eisentraut wrote:
>> But we already have a different syntax for attaching attributes to
>> constraints (NOT DEFERRABLE, NOT VALID,  etc.), so it would make more
>> sense to have
>> 
>> CHECK (foo > 0) NO INHERIT

> How about this?

>     CHECK (foo > 0) (INHERIT FALSE)

The SQL spec already says what the syntax is for options attached to
constraints, and that's not it.

			regards, tom lane