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 17:00:04
Message-ID: 12906.1140627604@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:
> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-02-22 17:23:39 Re: WAL recovery
Previous Message Christian Sengstock 2006-02-22 16:45:31 broken restore.sql script !?