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

[Richard Troy <rtroy(at)ScienceTools(dot)com>]

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(dot)avraham(at)gmail(dot)com>
> To: pgsql-bugs(at)postgresql(dot)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(dot)avraham(at)gmail(dot)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(at)ScienceTools(dot)com, http://ScienceTools.com/