Re: broken restore.sql script !? - Mailing list pgsql-admin

From Tom Lane
Subject Re: broken restore.sql script !?
Date
Msg-id 12906.1140627604@sss.pgh.pa.us
Whole thread Raw
In response to broken restore.sql script !?  ("Christian Sengstock" <csengstock@gmail.com>)
Responses Re: broken restore.sql script !?
List pgsql-admin
"Christian Sengstock" <csengstock@gmail.com> writes:
> The function is created outside of the 'geo' schema, but after that, the
> 'alter function' statement tries to alter the function inside of the 'geo'
> schema.

This is pg_dump's normal method of operation.  There should have been a
"SET search_path = geo, pg_catalog;" command somewhere before the
excerpt you gave.  I think you probably broke the script by carelessly
extracting a part of it...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Christian Sengstock"
Date:
Subject: broken restore.sql script !?
Next
From: Jeff Frost
Date:
Subject: Re: WAL recovery