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 Alvaro Herrera
Subject Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it
Date
Msg-id 20160616042732.GA47738@alvherre.pgsql
Whole thread Raw
In response to Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view 
Michael Paquier wrote:
> On Wed, Jun 15, 2016 at 10:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > IIRC, Alvaro posted a WIP patch for that awhile back.  Not sure what the
> > current state is.
> 
> Are you talking about that?
> https://www.postgresql.org/message-id/20110707213401.GA27098%40alvh.no-ip.org
> This is not a small patch :)
> 
> Alvaro, others, any opinions?

I haven't looked at this in a while.  I suppose I should get it in shape
sometime.  Unless you would like to work on it?

Note that Vitaly Burovoy rebased it, but I think the rebase is wrong.
https://www.postgresql.org/message-id/CAKOSWNkN6HSyatuys8xZxzRCR-KL1OkHS5-b9qd9bf1Rad3PLA@mail.gmail.com

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it
Next
From: Thomas Munro
Date:
Subject: Re: Typo in parallel comment of heap_delete()