Problem with capital letter in column name - Mailing list pgadmin-support

From Marc-André Goderre
Subject Problem with capital letter in column name
Date
Msg-id D8DAC91BA6256246BA3FF835F6AAA1180144133234@SI-MB02.cegep-chicoutimi.qc.ca
Whole thread Raw
Responses Re: Problem with capital letter in column name
Re: Problem with capital letter in column name
List pgadmin-support

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

 

pgadmin-support by date:

Previous
From: Neel Patel
Date:
Subject: Re: unable to start pgAdmin-4 on CentOS-7
Next
From: Patrick Headley
Date:
Subject: Re: Problem with capital letter in column name