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.
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? |