Tom Lane wrote:
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?
Sorry I failed to specify. Production version is 7.3.1 (change is hard!), although I origianally worked out the implementation on version 8. I bet that is the problem.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
