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  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: "abraham camacho"
Дата:
Сообщение: BUG #5764: installation error (incomplete process)
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #5765: pg_dump fail to find upper case table name