Re: Preserving data after updates

Tom Lane wrote:

>Berend Tober <btober@seaworthysys.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?
>

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.