[BUGS] BUG #2648: I can not create table name with capital and small characters

#1

The following bug has been logged online:

Bug reference: 2648
Logged by: Asaf Avraham
Email address: asaf.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

#2

------=_Part_25181_20996507.1159167803272
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 (AT) gmail (DOT) com> wrote:

Quote:

The following bug has been logged online:

Bug reference: 2648
Logged by: Asaf Avraham
Email address: asaf.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

--=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.l...hread/285b9ad=
eec188fb2

------=_Part_25181_20996507.1159167803272
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Asaf, this is not a bug. To use identifier names (identfiers =3D col=
umn-names, table-names, view-names...) with capital and small characters, y=
ou need to doublequote those names. So you can do select "Asaf&=
quot; from "Avraham"
 but not select Asaf from Avraham. This behaviour is documen=
ted and intended. Best wishes, Harald <div>On 9/24/06, Asaf Avraham
 <<a href=3D"mailto:asaf.avraham (AT) gmail (DOT) com">asaf.avraham (AT) gmail (DOT) com</=
a>> wrote:<blockquote class=3D"gmail_quote" style=3D"border-left:=
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex=
;">
 The following bug has been logged online: Bug reference: &n=
bsp;    2648 Logged by:    &nbsp=
;     Asaf Avraham Email address:  &n=
bsp;   <a href=3D"mailto:asaf.avraham (AT) gmail (DOT) com">asaf.avraha=
m (AT) gmail (DOT) com</a> PostgreSQL version:=20
<a href=3D"http://8.1.4.2">8.1.4.2</a> Operating system:   win=
 Description:     &nbs p;  I can not c=
reate 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 tab=
le postgres add inverted commas on the name When I'm running any que=
ry on this table i get: 1. select * from tblEmp    Get: ERR=
OR:  relation "tblemp" does not exist
 2. select * from "tblEmp"    Get: Resulted <b=
r>Thanks ---------------------------(end of broadcast)--------------=
------------- TIP 9: In versions below 8.0, the planner will ignore your=
desire to
        choose an index scan if your joini=
ng column's datatypes do not        match<=
br></blockquote></div> -- GHUM Harald Massa<br=

Quote:

persuadere et programmare Harald Armin Massa Reinsburgstra=DFe 202b
br>70197 Stuttgart 0173/9409607 - Python: the only language with =

more web frameworks than keywords. -- Harald A. Massa, December 2005 <b=
r><a href=3D"http://groups.google.de/group/comp.lang.python/browse_thread/t=
hread/285b9adeec188fb2">
http://groups.google.de/group/comp.l...hread/285b9ad=
eec188fb2</a>

------=_Part_25181_20996507.1159167803272--

#3

------=_Part_29593_3444529.1159189186928
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Asaf,

SQL-92 states that identifiers [for dictionary objects] are limited to 128
characters and are case-insensitive (unless delimited by double quotes),
because they are automatically translated into uppercase by the system.

Standards are SQL-92, SQL-99 and SQL-2003, done by ISO and other
standardization commitees.

It can be that JSP and ASP work different than standard SQL-92. I formyself
prefer the easiest solution: just not use mixed case identifiers.

Best wishes,

Harald

On 9/25/06, Asaf Avraham <asaf.avraham (AT) gmail (DOT) com> wrote:

Quote:

Harald,
This is the point, i need to use standard sql (from jsp, asp). and quote
is not a standard

Thanks
Asaf.

On 9/25/06, Harald Armin Massa <haraldarminmassa (AT) gmail (DOT) com> wrote:

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 (AT) gmail (DOT) com > wrote:

The following bug has been logged online:

Bug reference: 2648
Logged by: Asaf Avraham
Email address: asaf.avraham (AT) gmail (DOT) com
PostgreSQL version: 8.1.4.2
Operating system: win
Description: I can not create table name with capital and smal=
l
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=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.l...ad/thread/285=
b9adeec188fb2

--=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.l...hread/285b9ad=
eec188fb2

------=_Part_29593_3444529.1159189186928
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Asaf, SQL-92 states that identifiers [for dictionary
objects] are limited to 128 characters and are case-insensitive (unless del=
imited
by double quotes), because they are automatically translated into uppercase
by the system. Standards are SQL-92, SQL-99 and SQL-2003, done by IS=
O and other standardization commitees. It can be that JSP and ASP wo=
rk different than standard SQL-92. I formyself prefer the easiest solution:=
just not use mixed case identifiers.
 Best wishes, Harald <div><spa n class=3D"g=
mail_quote">On 9/25/06, Asaf Avraham <=
<a href=3D"mailto:asaf.avraham (AT) gmail (DOT) com">asaf.avraham (AT) gmail (DOT) com</a>> wr=
ote:
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rg=
b(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>Haral=
d,</div>
<div>This is the point, i need to  use standard sql (from jsp, as=
p). and quote is not a standard  </div>
<div>Thanks</div>
<div>Asaf.  </div><div>
<div>On 9/25/06, =
Harald Armin Massa <<a href=3D"mailto:haraldarminmassa (AT) gmail (DOT) com" ta=
rget=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">ha=
raldarminmassa (AT) gmail (DOT) com
</a>> wrote:
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">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 double=
quote 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 
 
<div>On 9/24/06, =
Asaf Avraham <<a href=3D"mailto:asaf.avraham (AT) gmail (DOT) com" target=3D"_b=
lank" onclick=3D"return top.js.OpenExtLink(window,event,this)">asaf.avraha m=
@gmail.com
</a>> wrote:=20
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> The following=
bug has been logged online: Bug reference:    &=
nbsp; 2648 Logged by:       &nbs=
p;  Asaf Avraham
 Email address:      <a href=3D"mailto:asa=
f.avraham (AT) gmail (DOT) com" target=3D"_blank" onclick=3D"return top.js.OpenExtLink=
(window,event,this)">asaf.avraham (AT) gmail (DOT) com</a> PostgreSQL version: <a h=
ref=3D"http://8.1.4.2/" target=3D"_blank" onclick=3D"return top.js.OpenExtL=
ink(window,event,this)">

8.1.4.2</a> Operating system:   win Description: &nbsp=
;      I can not create table name with capit=
al and small characters Details: I have table that contain nam=
e 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 W=
hen I'm running any query on this table i get: 1. select * from tblEmp<b=
r>   Get: ERROR:  relation "tblemp" does not =
exist 2. select * from "tblEmp"
    Get: Resulted Thanks -----------------------=
----(end of broadcast)--------------------------- TIP 9: In versions bel=
ow 8.0, the planner will ignore your desire to     =
   choose an index scan if your joining column's datatypes do not
        match </blockquote></div> <b=
r clear=3D"all"> -- GHUM Harald Massa persuadere et progra=
mmare Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stutt=
gart 0173/9409607
 - Python: the only language with more web frameworks than keywords.<=
br>-- Harald A. Massa, December 2005 <a href=3D"http://groups.google.de=
/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2" target=3D"_b=
lank" onclick=3D"return top.js.OpenExtLink(window,event,this)">

http://groups.google.de/group/comp.l...hread/285b9ad=
eec188fb2</a> </blockquote></div> 

</div></blockquote></div> -- GHUM Haral=
d Massa persuadere et programmare Harald Armin Massa Reinsburgstra=
=DFe 202b 70197 Stuttgart 0173/9409607 - Python: the only langu=
age with more web frameworks than keywords.
 -- Harald A. Massa, December 2005 <a href=3D"http://groups.google.=
de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2">http://gro=
ups.google.de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2
</a>

------=_Part_29593_3444529.1159189186928--

#4

On Mon, Sep 25, 2006 at 14:59:46 +0200,
Harald Armin Massa <haraldarminmassa (AT) gmail (DOT) com> wrote:

Quote:

Asaf,

SQL-92 states that identifiers [for dictionary objects] are limited to 128
characters and are case-insensitive (unless delimited by double quotes),
because they are automatically translated into uppercase by the system.

Note that Postgres actually lowercases unquoted names instead of uppercasing
them. This difference can be significant.

---------------------------(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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] BUG #2648: I can not create table name with capital and small characters

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] BUG #2648: I can not create table name with capital and small characters - 09-24-2006 , 04:15 PM

Re: [BUGS] BUG #2648: I can not create table name with capital and small characters - 09-25-2006 , 02:05 AM

Re: [BUGS] BUG #2648: I can not create table name with capital and small characters - 09-25-2006 , 08:02 AM

Re: [BUGS] BUG #2648: I can not create table name with capital and small characters - 09-29-2006 , 12:24 AM