Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc-André Goderre
Subject Re: Problem with capital letter in column name
Date
Msg-id D8DAC91BA6256246BA3FF835F6AAA1180144133283@SI-MB02.cegep-chicoutimi.qc.ca
Whole thread Raw
In response to Re: Problem with capital letter in column name  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
Tree view

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 by date:

Previous
From: Dave Page
Date:
Subject: Re: Problem with capital letter in column name
Next
From: Venkata Balaji N
Date:
Subject: Re: unable to start pgAdmin-4 on CentOS-7