The following bug has been logged online:
Bug reference: 2648
Logged by: Asaf Avraham
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4.2
Operating system: win
Description: I can not create table name with capital and small
characters
Details:
I have table that contain name with capital and small characters (ex.
tblEmp). In the columns is the same (ex. EmpID).
In Creating table postgres add inverted commas on the name
When I'm running any query on this table i get:
1. select * from tblEmp
Get: ERROR: relation "tblemp" does not exist
2. select * from "tblEmp"
Get: Resulted
Thanks
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
