Postgres Pro
Downloads
Home   >   mailing lists

Re: how to create a non-inherited CHECK constraint in CREATE TABLE - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: how to create a non-inherited CHECK constraint in CREATE TABLE
Date
Msg-id 41037205-7485-4D70-9A52-B347E0F158F5@nasby.net
Whole thread Raw
In response to Re: how to create a non-inherited CHECK constraint in CREATE TABLE  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: how to create a non-inherited CHECK constraint in CREATE TABLE  (Nikhil Sontakke <nikkhils@gmail.com>)
List pgsql-hackers
Tree view 
On Jan 17, 2012, at 11:07 AM, Alvaro Herrera wrote:
> Excerpts from Peter Eisentraut's message of mar ene 17 13:59:57 -0300 2012:
>> It appears that the only way to create a non-inherited CHECK constraint
>> is using ALTER TABLE.  Is there no support in CREATE TABLE planned?
>> That looks a bit odd.
>
> There are no plans to do that AFAIR, though maybe you could convince
> Nikhil to write the patch to do so.

That certainly doesn't meet the principle of least surprise... CREATE TABLE should support this.
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Why is CF 2011-11 still listed as "In Progress"?
Next
From: Jim Nasby
Date:
Subject: Re: 9.3 feature proposal: vacuumdb -j #