Re: Problem with capital letter in column name

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Marc-André Goderre <magoderre(at)cgq(dot)qc(dot)ca>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Problem with capital letter in column name
Date: 2016-08-08 19:29:04
Message-ID: 55A986C7-751E-451C-9456-C5AE53F5EF7C@pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Marc-André Goderre 2016-08-08 19:30:00 Re: Problem with capital letter in column name
Previous Message Patrick Headley 2016-08-08 19:04:21 Re: Problem with capital letter in column name