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 [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
