Berend Tober <btober@xxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings