BUG #8092: pg_dump need sur quoting schema name
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="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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
xavier.mouton-dubosc@notalus.fr wrote:
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 foundI have to surquote schema name to have it working
pg_dump -s --schema="\"other\"" [...]seems strange
Does your "other" schema have uppercase letters or some such?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Yes.
structure is kind of [a-zA-Z0-9\-_]{4,}
Le 18/04/2013 17:00, Alvaro Herrera a écrit :
xavier.mouton-dubosc@notalus.fr wrote:
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 foundI have to surquote schema name to have it working
pg_dump -s --schema="\"other\"" [...]seems strange
Does your "other" schema have uppercase letters or some such?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs