BUG #8092: pg_dump need sur quoting schema name

From: xavier(dot)mouton-dubosc(at)notalus(dot)fr
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8092: pg_dump need sur quoting schema name
Date: 2013-04-18 13:23:34
Message-ID: E1USooI-0002WN-Hh@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8092
Logged by: Xavier Mouton-Dubosc
Email address: xavier(dot)mouton-dubosc(at)notalus(dot)fr
PostgreSQL version: 9.2.4
Operating system: Linux Ubuntu 12.10
Description:

When I dump "default" schema
pg_dump -s --schema="default" --username="user" --host="localhost"
--quote-all-identifiers --serializable-deferrable "base"

works well. But when I try to dump "other" schema
pg_dump -s --schema="other" [...]

I have this error:
pg_dump: No matching schemas were found

I have to surquote schema name to have it working
pg_dump -s --schema="\"other\"" [...]

seems strange

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2013-04-18 15:00:35 Re: BUG #8092: pg_dump need sur quoting schema name
Previous Message haribabu.kommi 2013-04-18 11:18:09 BUG #8091: No permissions on the table file causing recovery failure