Postgres Pro
Downloads
Home   >   mailing lists

Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it
Date
Msg-id CAB7nPqSzst4C3fU4fv4nbrOfzy9PC3jyR0QkW-yZsE574dSY-g@mail.gmail.com
Whole thread Raw
In response to Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Responses Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Next
From: Alvaro Herrera
Date:
Subject: Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it