BUG #5765: pg_dump fail to find upper case table name
От | Cristiano |
---|---|
Тема | BUG #5765: pg_dump fail to find upper case table name |
Дата | |
Msg-id | 201011241134.oAOBY8YQ016066@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5765: pg_dump fail to find upper case table name
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5765 Logged by: Cristiano Email address: sumariva@gmail.com PostgreSQL version: 8.4.4 Operating system: Linux Description: pg_dump fail to find upper case table name Details: The following command line did not worked. Using a table with lower case chars( no quoting ) works. Also happen on pg_dump windows version. Tested on 8.4.4 and 8.4.3 pg_dump --host www --port 5432 --username postgres --format plain --column-inserts --verbose --file "streetTypes.sql" --table public."streetTypes" "geocoding-dev" Password: pg_dump: No matching tables were found pg_dump: *** aborted because of error Test case: just create an table that need quoting. CREATE TABLE "Test"() WITH ( OIDS=FALSE ); Call pg_dump to export. pg_dump --host localhost --port 5432 --username postgres --format plain --column-inserts --verbose --file "test.sql" --table public."Test" "test-db"
В списке pgsql-bugs по дате отправления: