--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
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
"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