pg_dumpall outputs incorrect sql

From: David Mitchell <david(dot)mitchell(at)telogis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dumpall outputs incorrect sql
Date: 2004-08-16 23:42:39
Message-ID: 4121466F.207@telogis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-16 23:44:41 Re: Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?
Previous Message Ed L. 2004-08-16 23:26:14 Re: Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?