Postgres Pro
Downloads
Home   >   mailing lists

BUG #8092: pg_dump need sur quoting schema name - Mailing list pgsql-bugs

From xavier.mouton-dubosc@notalus.fr
Subject BUG #8092: pg_dump need sur quoting schema name
Date
Msg-id E1USooI-0002WN-Hh@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8092: pg_dump need sur quoting schema name  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      8092
Logged by:          Xavier Mouton-Dubosc
Email address:      xavier.mouton-dubosc@notalus.fr
PostgreSQL version: 9.2.4
Operating system:   Linux Ubuntu 12.10
Description:        =


When I dump "default" schema
pg_dump -s  --schema=3D"default" --username=3D"user" --host=3D"localhost" =

--quote-all-identifiers --serializable-deferrable "base"

works well. But when I try to dump "other" schema
pg_dump -s  --schema=3D"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=3D"\"other\"" [...]

seems strange

pgsql-bugs by date:

Previous
From: haribabu.kommi@huawei.com
Date:
Subject: BUG #8091: No permissions on the table file causing recovery failure
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #8092: pg_dump need sur quoting schema name