| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Berend Tober <btober(at)computer(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Preserving data after updates |
| Date: | 2005-05-20 02:26:07 |
| Message-ID: | 15352.1116555967@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Berend Tober <btober(at)computer(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-05-20 02:48:09 | Re: Locale C? |
| Previous Message | Berend Tober | 2005-05-20 02:23:11 | Re: Preserving data after updates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-05-20 03:27:18 | Inherited constraints and search paths (was Re: Preserving data after updates) |
| Previous Message | Berend Tober | 2005-05-20 02:23:11 | Re: Preserving data after updates |