create database test;
\c test
create table base (foo int not null);
create table derived () inherits (base);
alter table derived alter foo drop not null;
insert into derived values(null);
Dump it, and the dump will not include any command to drop the not null
constraint on derived.foo, so restore will fail.
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice