Re: pg_dump of non nublic schema causes problems on restore.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: "'PgSql General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump of non nublic schema causes problems on restore.
Date: 2008-09-24 13:35:58
Message-ID: 400.1222263358@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howard Cole <howardnews(at)selestial(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-09-24 14:12:19 Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Previous Message Howard Cole 2008-09-24 11:59:06 pg_dump of non nublic schema causes problems on restore.