On 10/21/2013 12:50 AM, Ken Tanzer wrote:
When trying to move a database from 8.3 to 9.2.5, the plain text pg_dump
did not restore without errors. (I used pg_dump from 9.2.5) The
problem seems to relate to references to other schemas and the schema
search paths.
First, here's the error message:
psql:/tmp/spc_test_1005_dump_with_pg_9_2_5.orig.sql:451247: ERROR:
relation "tbl_housing_unit" does not exist
LINE 3: SELECT a.housing_project_code FROM tbl_housing_unit a WHERE...
^
QUERY:
SELECT a.housing_project_code FROM tbl_housing_unit a WHERE
LOWER(a.housing_unit_code)=LOWER($1) LIMIT 1;
CONTEXT: SQL function "housing_project_from_unit" during inlining
COPY tbl_unit_absence, line 1: "1 [data snipped] \..."
But I haven't seen anything that indicates this should stop a pg_dump
from working, and so wonder if this should be reported as a bug. It
might be a known limitation, or maybe it's just tough luck if you cross
schemas?
I'm happy to provide more information if it's helpful. Thanks.
What was the pg_dump command you used to dump the database?
So to be clear, housing_project_from_unit was not restored at all unless
you manually changed the search_path or did Postgres throw an error at
restore it at a later point?
Ken
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
