pg_dumpall outputs incorrect sql

[David Mitchell]

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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Tom Lane]

David Mitchell <da************@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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)