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