Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall outputs incorrect sql - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dumpall outputs incorrect sql
Date
Msg-id 18907.1092701220@sss.pgh.pa.us
Whole thread Raw
In response to pg_dumpall outputs incorrect sql  (David Mitchell <david.mitchell@telogis.com>)
List pgsql-general
Tree view 
David Mitchell <david.mitchell@telogis.com> writes:
> psql:globals.dump:17: ERROR:  schema "dbmirror, public, pg_catalog" does
> not exist

> However, if I take the quotes off the search_path it works perfectly. Is
> there something I'm not doing right or is this a bug?

This is a known bug.  It appears to be fixed in 8.0beta.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?
Next
From: "Glen Parker"
Date:
Subject: pg_clog and pg_xlog empty, postgresql refuses to start