it was showing for the keyword 'giz'. u mentioned that you are using postgres 8.4, do we necessarily have to use 8.4. I am getting the error when using 8.2.
Does the SQL generated as shown in the error seem correct to you. Thanks, Rohit -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253341.html Sent from the OFBiz - User mailing list archive at Nabble.com.