Berend Tober <btober(at)seaworthysys(dot)com> writes:
> But after doing a dump of the modified data base, the script created by
> pg dump wants to recreate the history table as
> ...
> CONSTRAINT person_name_check CHECK (((last_name IS NOT NULL) OR
> (first_name IS NOT NULL))),
Hmm, it shouldn't do that ... and in a quick test here I couldn't
reproduce any such bug. What version of pg_dump are you using?
regards, tom lane