The following bug has been logged online:
Bug reference: 3973
Logged by: Alex Hunsaker
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0
Operating system: Linux
Description: pg_dump using inherited tables do not always restore
Details:
create table junk (val integer not null, val2 integer);
create table junk_child () inherits (junk_1);
alter table junk_child alter column val drop not null;
insert into junk_child (val2) values (1);
pg_dump -t junk -t junk_child
pg_restore/psql will fail because junk_child.val now has a not null
constraint
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
