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
>
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 |