Re: BUG #14325: backup restore inherited constraint

On Tue, Sep 20, 2016 at 1:14 AM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

> On Fri, Sep 16, 2016 at 3:27 PM, <vbv256(at)yandex(dot)ru> wrote:
> > If child table has field with removed inherit constraint.
> > In dump file this constraint not removed and data not restored correctly.
> > Problem also exist in PostgreSQL 9.1. Before this version appropriate
> > construction not used by me.
> >
> > -- --- to reproduce problem ----------
> > bash$ psql template1
> > template1=# create database test;
> > template1=# \c test
> >
> > [... test ...]
>
> What we ought to do here is forbid DROP NOT NULL on the table test.
>

+1 for this approach. Just encountered with the same behavior.