Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it
Дата
Msg-id CAB7nPqSzst4C3fU4fv4nbrOfzy9PC3jyR0QkW-yZsE574dSY-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Ответы Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Список pgsql-hackers
On Thu, Jun 16, 2016 at 12:10 PM, Vitaly Burovoy
<vitaly.burovoy@gmail.com> wrote:
> In the initial letter[1] I posted a digest from the SQL-2011 standard
> and a conclusion as a design of a new patch.
> Now I have more free time and I'm hacking it that way. The new patch
> is at the very early stage, full of WIPs and TODOs. I hope it'll be
> ready to be shown in a month (may be two).

I have just read both your patch and the one of Alvaro, but yours does
not touch pg_constraint in any way. Isn't that unexpected?

> But it already forbids dropping NOT NULLs if they were set as result
> of inheritance.

Okay, I'll drop any proposal on my side in this case. Looking forward
to seeing what you got for the first commit fest of 10.0.
-- 
Michael



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it