Skip site navigation (1) Skip section navigation (2)

Re: BUG #1100: pd_dump doesn't work with upper case table names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wjerickson(at)lucent(dot)com
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1100: pd_dump doesn't work with upper case table names
Date: 2004-03-11 20:43:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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);
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

In response to

pgsql-bugs by date

Next:From: Janko RichterDate: 2004-03-11 22:14:47
Subject: Re: BUG #1096: pg_restore cannot restore large objects with
Previous:From: Tom LaneDate: 2004-03-11 20:26:01
Subject: Re: Glitch: cannot use Arrays with Raise Notice

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group