| From: | "Cristiano" <sumariva(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5765: pg_dump fail to find upper case table name |
| Date: | 2010-11-24 11:34:08 |
| Message-ID: | 201011241134.oAOBY8YQ016066@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5765
Logged by: Cristiano
Email address: sumariva(at)gmail(dot)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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2010-11-24 13:28:02 | Re: BUG #5765: pg_dump fail to find upper case table name |
| Previous Message | Bruce Momjian | 2010-11-24 05:14:45 | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |