Обсуждение: 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:=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.
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