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
обсуждение исходный текст
Ответ на 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  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
 
>> 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.

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

But, let me have a stab at it when I get some free cycles. 

Regards,
Nikhils

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [v9.2] LEAKPROOF attribute of FUNCTION (Re: [v9.2] Fix Leaky View Problem)
Следующее
От: Noah Misch
Дата:
Сообщение: Re: psql \timing vs failed statements