Thank you for the response.

Marc

De : Dave Page [mailto:dp...@pgadmin.org]
Envoyé : 8 août 2016 15:29
À : Marc-André Goderre
Cc : pgadmin-support@postgresql.org
Objet : Re: [pgadmin-support] Problem with capital letter in column name

This has already been fixed for beta 4. Thanks for the report though.

--
Dave Page
Blog: http://pgsnake.blogspot.com<http://pgsnake.blogspot.com/>
Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com<http://www.enterprisedb.com/>
The Enterprise PostgreSQL Company

On 8 Aug 2016, at 19:43, Marc-André Goderre 
<magode...@cgq.qc.ca<mailto:magode...@cgq.qc.ca>> 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

Reply via email to