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

Asaf,

quote them and it will work.

Richard

On Sun, 24 Sep 2006, Asaf Avraham wrote:

> Date: Sun, 24 Sep 2006 06:18:38 GMT
> From: Asaf Avraham <asaf.avraham@gmail.com>
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] BUG #2648: I can not create table name with capital and
>     small characters
>
>
> 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
>

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/