BUG #2764: Capital letter in tables or columns not supported - Mailing list pgsql-bugs

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.