Обсуждение: Problem with capital letter in column name

<div class="WordSection1"><p class="MsoNormal">I work with  an  existing database containing capital letter in column
name.<pclass="MsoNormal">When i want to view data from conextual meny, it always send an error : <p
class="MsoNormal">i.e.:<pclass="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">ERROR:column "idmunicipaliteexterne" does not exist </span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier New";color:#333333;background:white">LINE 2: ORDER
BYidMunicipaliteExterne </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">                 ^</span><p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"CourierNew";color:#333333;background:white">********** Error ********** </span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier New";color:#333333;background:white">ERROR: column
"idmunicipaliteexterne"does not exist </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">SQLstate: 42703 </span><p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"CourierNew";color:#333333;background:white">Character: 56</span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier New";color:#333333;background:white"> </span><p
class="MsoNormal"> <pclass="MsoNormal">It seems that pgadmin don't add the double quote in the ORDER BY clause when the
columnname has capital letters.<p class="MsoNormal"> <p class="MsoNormal">PGadmin 4 beta 3<p
class="MsoNormal">Postgresql9.1<p class="MsoNormal">Ubuntu server 12.04<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">Thanks<pclass="MsoNormal">Marc<span style="mso-fareast-language:FR-CA"></span><p
class="MsoNormal"> </div>

<p>Put double-quotes around it or else it will get rolled down to lower case and won't match the actual field name.<br
/><divclass="moz-signature"><b><i>Patrick Headley</i></b><br /> Linx Consulting, Inc.<br /><a
class="moz-txt-link-abbreviated"href="mailto:pheadley@linxco-inc.com">pheadley@linxco-inc.com</a><br /> (303)
916-5522<br/><a class="moz-txt-link-abbreviated" href="http://www.linxco-inc.com">www.linxco-inc.com</a></div><div
class="moz-cite-prefix">On08/08/2016 12:43 PM, Marc-André Goderre wrote:<br /></div><blockquote
cite="mid:D8DAC91BA6256246BA3FF835F6AAA1180144133234@SI-MB02.cegep-chicoutimi.qc.ca"type="cite"><style><!--
 
/* Font Definitions */
@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Texte de bulles
Car";margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-US;}
span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;}
span.TextedebullesCar{mso-style-name:"Texte de bulles Car";mso-style-priority:99;mso-style-link:"Texte de
bulles";font-family:"Tahoma","sans-serif";}
.MsoChpDefault{mso-style-type:export-only;font-family:"Calibri","sans-serif";mso-fareast-language:EN-US;}
@page WordSection1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1{page:WordSection1;}
--></style><div class="WordSection1"><p class="MsoNormal">I work with  an  existing database containing capital letter
incolumn name.<p class="MsoNormal">When i want to view data from conextual meny, it always send an error : <p
class="MsoNormal">i.e.:<pclass="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">ERROR:column "idmunicipaliteexterne" does not exist </span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier           New";color:#333333;background:white">LINE
2:ORDER BY idMunicipaliteExterne </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
 New";color:#333333;background:white">                 ^ </span><p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"Courier          New";color:#333333;background:white">********** Error **********
</span><pclass="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">ERROR:column "idmunicipaliteexterne" does not exist </span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier           New";color:#333333;background:white">SQL
state:42703 </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">Character:56</span><p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"Courier          New";color:#333333;background:white"> </span><p
class="MsoNormal"> <pclass="MsoNormal">It seems that pgadmin don't add the double quote in the ORDER BY clause when the
columnname has capital letters.<p class="MsoNormal"> <p class="MsoNormal">PGadmin 4 beta 3<p
class="MsoNormal">Postgresql9.1<p class="MsoNormal">Ubuntu server 12.04<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">Thanks<pclass="MsoNormal">Marc<span style="mso-fareast-language:FR-CA"></span><p
class="MsoNormal"> </div></blockquote><br/> 

I don't know the answer regarding configuring something. I just spotted the lack of double-quotes around the field name in

LINE 2: ORDER BY idMunicipaliteExterne

and the lack of a capital letter in ERROR: column "idmunicipaliteexterne" does not exist.

Thanks Patrick but I know that i have to add double-quotes with capital lettre. This issue happens only when I use the contextual menu (right click on table --> view data)

It automatically create the query and open the Query window with the result.

Do i must configure someting or is it a bug in pgAdmin4?

Thanks

Marc

 

De : pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] De la part de Patrick Headley
Envoyé : 8 août 2016 14:49
À : pgadmin-support@postgresql.org
Objet : Re: [pgadmin-support] Problem with capital letter in column name

 

Put double-quotes around it or else it will get rolled down to lower case and won't match the actual field name.

Patrick Headley
Linx Consulting, Inc.
pheadley@linxco-inc.com
(303) 916-5522
www.linxco-inc.com

On 08/08/2016 12:43 PM, Marc-André Goderre wrote:

I work with  an  existing database containing capital letter in column name.

When i want to view data from conextual meny, it always send an error :

i.e.:

ERROR: column "idmunicipaliteexterne" does not exist

LINE 2: ORDER BY idMunicipaliteExterne

                 ^

********** Error **********

ERROR: column "idmunicipaliteexterne" does not exist

SQL state: 42703

Character: 56

 

 

It seems that pgadmin don't add the double quote in the ORDER BY clause when the column name has capital letters.

 

PGadmin 4 beta 3

Postgresql 9.1

Ubuntu server 12.04

 

 

Thanks

Marc

 

 

I work with  an  existing database containing capital letter in column name.

When i want to view data from conextual meny, it always send an error :

i.e.:

ERROR: column "idmunicipaliteexterne" does not exist

LINE 2: ORDER BY idMunicipaliteExterne

                 ^

********** Error **********

ERROR: column "idmunicipaliteexterne" does not exist

SQL state: 42703

Character: 56

 

 

It seems that pgadmin don't add the double quote in the ORDER BY clause when the column name has capital letters.

 

PGadmin 4 beta 3

Postgresql 9.1

Ubuntu server 12.04

 

 

Thanks

Marc