The following bug has been logged online:
Bug reference: 2764
Logged by: Ron Teitelbaum
Email address: ron@usmedrec.com
PostgreSQL version: 1.4.1
Operating system: Windows
Description: Capital letter in tables or columns not supported
Details:
I ran into a very weird problem that tured out to be a capital letter in the
table name or column name. When trying to query a table with a capital
letter in the name I get error relation not defined.
I can get it to work with something like:
select * from "zipCodes"
It appears to be completely case insensitive if the table is all lowercase.
I get a simular problem with capital letters in column names. The error is
column not defined.
The table was created manually using PGAdmin.