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

2008-09-24 Thread Tom Lane
Howard Cole <[EMAIL PROTECTED]> 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...

[GENERAL] pg_dump of non nublic schema causes problems on restore.

2008-09-24 Thread Howard Cole
Appologies if this has already been fixed, but I have come across a problem with pg_dump when dumping a single non-public schema. (This is on Windows Pg 8.2). It did not cause any major problems because I obviously made a backup of the database before I tried a restore, and managed to fix the b