BUG #6024: pg_dump won't dump ALTERed inherited fields - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      6024
Logged by:          Panos Christeas
Email address:      xrg@linux.gr
PostgreSQL version: 9.0, 8.4
Operating system:   Linux
Description:        pg_dump won't dump ALTERed inherited fields
Details:

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" constraint at test2.name.