| From: | "Ron Teitelbaum" <ron(at)usmedrec(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2764: Capital letter in tables or columns not supported |
| Date: | 2006-11-17 19:40:35 |
| Message-ID: | 200611171940.kAHJeZcc062073@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2764
Logged by: Ron Teitelbaum
Email address: ron(at)usmedrec(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas H. | 2006-11-17 19:46:12 | Re: xlog lockup patch (was: BUG #2712: could not fsync segment: Permission) |
| Previous Message | carlos | 2006-11-17 15:47:56 | BUG #2763: fat |