Re: [BUGS] BUG #6024: pg_dump won't dump ALTERed inherited fields

2011-05-12 Thread Bernd Helmle
--On 12. Mai 2011 11:24:13 -0400 Tom Lane wrote: This is on the to-fix list --- in fact there was a patch submitted for it last year, although it got returned for rework and we've not seen it again yet. Yes, I didn't manage to provide a completed patch for 9.1...will try to re-submit for 9

Re: [BUGS] BUG #6024: pg_dump won't dump ALTERed inherited fields

2011-05-12 Thread P. Christeas
On Thursday 12 May 2011, you wrote: > "Panos Christeas" writes: > > CREATE TABLE test1(id SERIAL PRIMARY KEY, > > name VARCHAR(20) NOT NULL); > > CREATE TABLE test2(description TEXT) INHERITS(test1); > > ALTER TABLE test2 ALTER name DROP NOT NULL; > > > > pg_dump that. > > The dump will still

Re: [BUGS] BUG #6024: pg_dump won't dump ALTERed inherited fields

2011-05-12 Thread Tom Lane
"Panos Christeas" writes: > CREATE TABLE test1( > id SERIAL PRIMARY KEY, > name VARCHAR(20) NOT NULL > ); > CREATE TABLE test2( > description TEXT > ) INHERITS(test1); > ALTER TABLE test2 ALTER name DROP NOT NULL; > pg_dump that. > The dump will still have "not null" constr