this is not a bug. To use identifier names (identfiers = column-names, table-names, view-names...) with capital and small characters, you need to doublequote those names.
So you can do select "Asaf" from "Avraham"
but not select Asaf from Avraham.
This behaviour is documented and intended.
Best wishes,
Harald
On 9/24/06, Asaf Avraham
<[EMAIL PROTECTED]> wrote:
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
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
-- Harald A. Massa, December 2005
http://groups.google.de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2
