Re: broken restore.sql script !?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christian Sengstock" <csengstock(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: broken restore.sql script !?
Date: 2006-02-22 18:59:35
Message-ID: 14053.1140634775@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Christian Sengstock" <csengstock(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message CG 2006-02-22 19:55:45 Re: WAL recovery
Previous Message Christian Sengstock 2006-02-22 18:03:06 Re: broken restore.sql script !?