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.
*/Patrick Headley/*
Linx Consulting, Inc.
phead...@linxco-inc.com
(303) 916-5522
www.linxco-inc.com
On 08/08/2016 01:01 PM, Marc-André Goderre wrote:
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-ow...@postgresql.org
[mailto:pgadmin-support-ow...@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.
phead...@linxco-inc.com <mailto:phead...@linxco-inc.com>
(303) 916-5522
www.linxco-inc.com <http://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
