Re: BUG #6543: pgadmin III - Error defining filter.

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: kebe(dot)1969(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6543: pgadmin III - Error defining filter.
Date: 2012-03-19 21:29:21
Message-ID: 1332192561.2235.27.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 2012-03-19 at 17:47 +0000, kebe(dot)1969(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6543
> Logged by: Cleberson
> Email address: kebe(dot)1969(at)gmail(dot)com
> PostgreSQL version: 9.1.3
> Operating system: Windows 7
> Description:
>
> When you create a column name with uppercase ( idCustomer ) you can´t
> define a filter to thi col, because internaly de pgadmin converts the name
> to ( idcustomer ) and show an error that the column does not exist.
>

pgAdmin doesn't. PostgreSQL does. If you want to filter, you need to put
your column between double quotes.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Aren Cambre 2012-03-19 21:43:23 Re: BUG #6535: LEFT JOIN on large table is altering data
Previous Message Alvaro Herrera 2012-03-19 21:23:03 Re: BUG #6535: LEFT JOIN on large table is altering data