The following bug has been logged online:
Bug reference: 6024
Logged by: Panos Christeas
Email address: xrg(at)linux(dot)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.