BUG #1100: pd_dump doesn't work with upper case table names
The following bug has been logged online:
Bug reference: 1100
Logged by: Bill Erickson
Email address: wjerickson@lucent.com
PostgreSQL version: 7.4
Operating system: Solaris 9
Description: pd_dump doesn't work with upper case table names
Details:
I have found that in PG 7.4.1 the dump_pg command
no longer seems to work with upper case table names.
Here is how I am using the command:
pg_dump -h pglocalhost -U scncraft -a -d -t SA_SSN;
If I change the table name to lower case the command
will work.
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
I have found that in PG 7.4.1 the dump_pg command
no longer seems to work with upper case table names.
Works fine for me:
regression=# create table "SA_SSN" ("F1" int);
CREATE TABLE
regression=# \q
$ pg_dump -t SA_SSN regression
-- (produces dump of table)
$ pg_dump -t sa_ssn regression
pg_dump: specified table "sa_ssn" does not exist
Are you quite sure you created the table with an upper-case name?
Also: some time back, we had versions of pg_dump that behaved
differently in this respect; perhaps you are mistakenly invoking an
old pg_dump. (Though I'd think that a pg_dump that old would fail
completely against a 7.4 server anyway ...)
regards, tom lane
Guten Tag PostgreSQL Bugs List,
am Donnerstag, 11. Mï¿œrz 2004 um 21:15 schrieben Sie:
PBL> The following bug has been logged online:
PBL> Bug reference: 1100
PBL> Logged by: Bill Erickson
PBL> Email address: wjerickson@lucent.com
PBL> PostgreSQL version: 7.4
PBL> Operating system: Solaris 9
PBL> Description: pd_dump doesn't work with upper case table names
PBL> Details:
Hi Bill,
PBL> Here is how I am using the command:
PBL> pg_dump -h pglocalhost -U scncraft -a -d -t SA_SSN;
You have to set the bd-name in quotes. Then the command
pg_dump -h pglocalhost -U scncraft -a -d -t "SA_SSN";
should work.
Regards
Rico