The following bug has been logged online:
Bug reference: 6024
Logged by: Panos Christeas
Email address: [email protected]
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.
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
