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

BUG #6543: pgadmin III - Error defining filter.

From
kebe.1969@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      6543
Logged by:          Cleberson
Email address:      kebe.1969@gmail.com
PostgreSQL version: 9.1.3
Operating system:   Windows 7
Description:=20=20=20=20=20=20=20=20

When you create a column name with uppercase ( idCustomer ) you can=C2=B4t
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.

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

From
Guillaume Lelarge
Date:
On Mon, 2012-03-19 at 17:47 +0000, kebe.1969@gmail.com wrote:
> The following bug has been logged on the website:
>=20
> Bug reference:      6543
> Logged by:          Cleberson
> Email address:      kebe.1969@gmail.com
> PostgreSQL version: 9.1.3
> Operating system:   Windows 7
> Description:=20=20=20=20=20=20=20=20
>=20
> When you create a column name with uppercase ( idCustomer ) you can=C2=B4t
> 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.
>=20

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


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