Hello,
I noticed that when pg_dump saves SQL code for a table with inheritance, it
does not save any information about inherited columns. This is fine when
inherited columns do not undergo any modification, but when they do, that
information is lost.
Example:
create table parent (id integer not null);
create table child (value integer) inherits (parent);
alter table child alter column id drop not null;
insert into child values (null, 1);
Here is the code of the child table as generated by pg_dump:
CREATE TABLE child (
value integer
)
INHERITS (parent);
When the table is recreated using this code, the id column has the NOT NULL
restriction, which was not present in the original.
I don't think this is right. Either inherited columns should be immune to
changes, or else pg_dump should reflect those changes in its SQL code.
Dmitry
Dmitry Epstein | Developer
Allied Testing
T + 7 495 544 48 69 Ext 417
M + 7 926 215 73 36
www.alliedtesting.com<http://www.alliedtesting.com/>
We Deliver Quality.
