Re: Problem with capital letter in column name
| От | Marc-André Goderre |
|---|---|
| Тема | Re: Problem with capital letter in column name |
| Дата | |
| Msg-id | D8DAC91BA6256246BA3FF835F6AAA1180144133283@SI-MB02.cegep-chicoutimi.qc.ca обсуждение исходный текст |
| Ответ на | Re: Problem with capital letter in column name (Dave Page <dpage@pgadmin.org>) |
| Список | pgadmin-support |
Thank you for the response.
Marc
De : Dave Page [mailto:dpage@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
Twitter: @pgsnake
EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On 8 Aug 2016, at 19:43, Marc-André Goderre <magoderre@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
В списке pgadmin-support по дате отправления: