Re: Problem with capital letter in column name

Thank you for the response.

Marc

De : Dave Page [mailto:dpage(at)pgadmin(dot)org]
Envoyé : 8 août 2016 15:29
À : Marc-André Goderre
Cc : pgadmin-support(at)postgresql(dot)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 <magoderre(at)cgq(dot)qc(dot)ca<mailto:magoderre(at)cgq(dot)qc(dot)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