pg_dumpall outputs incorrect sql

Started by David Mitchellover 21 years ago2 messagesgeneral
Jump to latest
#1David Mitchell
david.mitchell@telogis.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: David Mitchell (#1)
Re: pg_dumpall outputs incorrect sql

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