Re: CHECK NO INHERIT syntax - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CHECK NO INHERIT syntax
Date
Msg-id 19361.1342742741@sss.pgh.pa.us
Whole thread Raw
In response to Re: CHECK NO INHERIT syntax  (David Fetter <david@fetter.org>)
List 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


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: pgbench -i order of vacuum
Next
From: Mark Kirkwood
Date:
Subject: Re: 2GB limit for temp_file_limit on 32bit platform