BUG #5765: pg_dump fail to find upper case table name

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: Raw Message | Whole Thread | 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"

Responses

Browse pgsql-bugs by date

  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