Re: Problem with capital letter in column name

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Problem with capital letter in column name
Дата
Msg-id 55A986C7-751E-451C-9456-C5AE53F5EF7C@pgadmin.org
обсуждение исходный текст
Ответ на Problem with capital letter in column name  (Marc-André Goderre <magoderre@cgq.qc.ca>)
Ответы Re: Problem with capital letter in column name  (Marc-André Goderre <magoderre@cgq.qc.ca>)
Список pgadmin-support
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 по дате отправления:

Предыдущее
От: Patrick Headley
Дата:
Сообщение: Re: Problem with capital letter in column name
Следующее
От: Marc-André Goderre
Дата:
Сообщение: Re: Problem with capital letter in column name