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

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it
Date: 2016-06-16 04:27:32
Message-ID: 20160616042732.GA47738@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Paquier wrote:
> On Wed, Jun 15, 2016 at 10:34 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2016-06-16 04:32:28 Re: Typo in parallel comment of heap_delete()
Previous Message Michael Paquier 2016-06-16 04:21:45 Re: Prevent ALTER TABLE DROP NOT NULL on child tables if parent column has it