BUG #6543: pgadmin III - Error defining filter.
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:
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.
On Mon, 2012-03-19 at 17:47 +0000, kebe.1969@gmail.com wrote:
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: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