Re: how to create a non-inherited CHECK constraint in CREATE TABLE
От
Nikhil Sontakke
Тема
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE
Дата
Msg-id
CANgU5Zff1a-e2_VAjdcOKypiweTq-Gm+RacUTRkEB5PaeE9jBg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
how to create a non-inherited CHECK constraint in CREATE TABLE Peter Eisentraut <peter_e@gmx.net>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Jim Nasby <jim@nasby.net>
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE Nikhil Sontakke <nikkhils@gmail.com>
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE Robert Haas <robertmhaas@gmail.com>
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE Peter Eisentraut <peter_e@gmx.net>
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE Nikhil Sontakke <nikkhils@gmail.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Tom Lane <tgl@sss.pgh.pa.us>
Re: how to create a non-inherited CHECK constraint in CREATE
TABLE Andrew Dunstan <andrew@dunslane.net>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Tom Lane <tgl@sss.pgh.pa.us>
Re: how to create a non-inherited CHECK constraint in CREATE
TABLE Andrew Dunstan <andrew@dunslane.net>
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE Robert Haas <robertmhaas@gmail.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Tom Lane <tgl@sss.pgh.pa.us>
Re: how to create a non-inherited CHECK constraint in
CREATE TABLE Nikhil Sontakke <nikkhils@gmail.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Noah Misch <noah@leadboat.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Nikhil Sontakke <nikkhils@gmail.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Alvaro Herrera <alvherre@commandprompt.com>
Re: how to create a non-inherited CHECK constraint in CREATE TABLE Nikhil Sontakke <nikkhils@gmail.com>
>> It appears that the only way to create a non-inherited CHECK constraintThat certainly doesn't meet the principle of least surprise... CREATE TABLE should support this.
>> 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.
Well, the above was thought about during the original discussion and eventually we felt that CREATE TABLE already has other issues as well, so not having this done as part of creating a table was considered acceptable then:
http://postgresql.1045698.n5.nabble.com/Check-constraints-on-partition-parents-only-tt4633334.html#a4647144
http://postgresql.1045698.n5.nabble.com/Check-constraints-on-partition-parents-only-tt4633334.html#a4647144
But, let me have a stab at it when I get some free cycles.
Regards,
Nikhils
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
