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