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

From Tom Lane
Subject Re: broken restore.sql script !?
Date
Msg-id 14053.1140634775@sss.pgh.pa.us
Whole thread Raw
In response to Re: broken restore.sql script !?  ("Christian Sengstock" <csengstock@gmail.com>)
List pgsql-admin
"Christian Sengstock" <csengstock@gmail.com> writes:
> does that mean a prior "SET search_path =3D geo, pg_catalog;" would create =
> the
> function inside of the geo schema ? i have this setting but it's not workin=
> g
> for me, despite the function is in the public schema.

> i use /> psql -d mydb -U user -f restore.sql

> to restore it. Could the behaviour be different when using 'pg_restore'  ?

Shouldn't be different.  Can you provide a test case?

            regards, tom lane

pgsql-admin by date:

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