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

From Tom Lane
Subject Re: Preserving data after updates
Date
Msg-id 15352.1116555967@sss.pgh.pa.us
Whole thread Raw
In response to Re: Preserving data after updates  (Berend Tober <btober@computer.org>)
List pgsql-general
Berend Tober <btober@computer.org> writes:
> Interesting. The consrc column values differ in that the explicit schema
> qualification on the function calls is missing for the descendent table.
> So, you think maybe if I remove the explicit schema qualification from
> the function calls in the constraint declarations on the person table
> that that might fix it? Yup! That does it!

OK.  This is a variant of the old problems that we had with relying on
consrc to dump constraints.  pg_dump hasn't done that for awhile, so
I expect the problem is gone in more recent releases.

            regards, tom lane

pgsql-general by date:

Previous
From: Berend Tober
Date:
Subject: Re: Preserving data after updates
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Locale C?