Re: BUG #2648: I can not create table name with capital and small characters

Asaf,

this is not a bug. To use identifier names (identfiers =3D 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 <asaf.avraham@gmail.com> wrote:
>
>
> The following bug has been logged online:
>
> Bug reference:      2648
> Logged by:          Asaf Avraham
> Email address:      asaf.avraham@gmail.com
> 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
>



--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstra=DFe 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/285b9ad=
eec188fb2