Re: Preserving data after updates - Mailing list pgsql-general

From Berend Tober
Subject Re: Preserving data after updates
Date
Msg-id 428CB8C6.1090501@seaworthysys.com
Whole thread Raw
In response to Re: Preserving data after updates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Preserving data after updates
List pgsql-general
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.



pgsql-general by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: Count and Results together
Next
From: Scott Marlowe
Date:
Subject: Re: Shared memory and FreeBSD's jail()