| 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 |