Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump of non nublic schema causes problems on restore. - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump of non nublic schema causes problems on restore.
Date
Msg-id 400.1222263358@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump of non nublic schema causes problems on restore.  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Tree view 
Howard Cole <howardnews@selestial.com> writes:
> The problem here is that table1 gets created in the public schema, not
> myschema, presumably because the search path is no longer valid after
> the drop schema.

This is fixed in 8.3.  I'm not real sure why the fix wasn't
back-patched...

            regards, tom lane

pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: pg_dump of non nublic schema causes problems on restore.
Next
From: Glyn Astill
Date:
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)