Re: [GENERAL] pg_dump problem with dropped NOT NULL on child table

2016-01-14 Thread Adrian Klaver
On 01/14/2016 12:59 AM, Karsten Hilbert wrote: On Wed, Jan 13, 2016 at 12:10:15PM -0800, Adrian Klaver wrote: On 01/13/2016 11:38 AM, Karsten Hilbert wrote: create table parent ( not_null_in_parent integer not null ); create table child() inherits (pa

Re: [GENERAL] pg_dump problem with dropped NOT NULL on child table

2016-01-14 Thread Karsten Hilbert
On Wed, Jan 13, 2016 at 03:32:12PM -0500, Tom Lane wrote: > Karsten Hilbert writes: > > create table parent ( > > not_null_in_parent integer not null > > ); > > > create table child() inherits (parent); > > alter table child > > alter column not_null_in_p

Re: [GENERAL] pg_dump problem with dropped NOT NULL on child table

2016-01-14 Thread Karsten Hilbert
On Wed, Jan 13, 2016 at 12:10:15PM -0800, Adrian Klaver wrote: > On 01/13/2016 11:38 AM, Karsten Hilbert wrote: > > create table parent ( > > not_null_in_parent integer not null > > ); > > > > create table child() inherits (parent); > > alter table child > >

Re: [GENERAL] pg_dump problem with dropped NOT NULL on child table

2016-01-13 Thread Tom Lane
Karsten Hilbert writes: > Please consider the following: > create table parent ( > not_null_in_parent integer not null > ); > create table child() inherits (parent); > alter table child > alter column not_null_in_parent >

Re: [GENERAL] pg_dump problem with dropped NOT NULL on child table

2016-01-13 Thread Adrian Klaver
On 01/13/2016 11:38 AM, Karsten Hilbert wrote: Please consider the following: - Debian - server is PG 9.4.5 - client (psql/pg_dump/libpq5) is 9.5 create table parent ( not_null_in_parent integer not null ); create table child() inherits (parent);

[GENERAL] pg_dump problem with dropped NOT NULL on child table

2016-01-13 Thread Karsten Hilbert
Please consider the following: - Debian - server is PG 9.4.5 - client (psql/pg_dump/libpq5) is 9.5 create table parent ( not_null_in_parent integer not null ); create table child() inherits (parent); alter table child alter column n