Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Page
Subject Re: Problem with capital letter in column name
Date
Msg-id 55A986C7-751E-451C-9456-C5AE53F5EF7C@pgadmin.org
Whole thread Raw
In response to Problem with capital letter in column name  (Marc-André Goderre <magoderre@cgq.qc.ca>)
Responses Re: Problem with capital letter in column name  (Marc-André Goderre <magoderre@cgq.qc.ca>)
List pgadmin-support
Tree view
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 by date:

Previous
From: Patrick Headley
Date:
Subject: Re: Problem with capital letter in column name
Next
From: Marc-André Goderre
Date:
Subject: Re: Problem with capital letter in column name