The following bug has been logged online:

Bug reference: 1137
Logged by: David Martin

Email address: d.m.a.martin (AT) dundee (DOT) ac.uk

PostgreSQL version: 7.4

Operating system: Debian Linux

Description: Error finding columns with mixed case names

Details:

I have the following table:
psql> \d reporter
Table "public.reporter"
Column | Type |
Modifiers
---------------+-----------------------------+-----------------------------
----------------------------------------
id | integer | not null default
nextval('Reporter_id_seq'::text)
reporterId | character varying(255) | not null default
''::character varying
species | character varying(255) | not null default
''::character varying
clusterId | integer | not null default 0
geneName | character varying(255) | not null default
''::character varying
geneSymbol | character varying(255) | not null default
''::character varying
lastUpdate | timestamp without time zone | not null default '0001-01-01
00:00:00'::timestamp without time zone
length | integer | default 0
sequence | text |
vector | text |
tissue | text |
library | text |
accession | character varying(255) |
nid | character varying(255) |
chromosome | character varying(255) |
cytoBand | character varying(255) |
markers | character varying(255) |
antibiotics | character varying(255) |
locusLink | integer | default 0
omim | integer | default 0
startPosition | integer | default 0
endPosition | integer | default 0
Indexes:
"reporter_pkey" primary key, btree (id)
"reporter_reporterid_index" unique, btree ("reporterId")
"reporter_genename_index" btree ("geneName")

When I try to retrieve from this table with 'select * from reporter;' it
works fine.

If I try to retrieve from any column with a mixed case name then I get the
following:

psql> select reporterId from reporter;
ERROR: column "reporterid" does not exist

It doesn't work if I use all lower case for the column name

psql> select reporterid from reporter;
ERROR: column "reporterid" does not exist




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html