Обсуждение: pg_dumpall outputs incorrect sql

I have a database in which there is a user and their search path is set to:

dbmirror, public, pg_catalog

pg_dumpall includes this line in the dump:

ALTER USER dbmirror SET search_path TO 'dbmirror, public, pg_catalog';

This isn't correct though, because when it is run through psql to load
the user, I get the following:

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?

I'm using Postgres 7.4.3

Regards
--
David Mitchell
Software Engineer
Telogis

NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law.  If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.

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