On Fri, Sep 16, 2016 at 3:27 PM, <vbv256@yandex.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.