....
I have an Application (www.phpgroupware), which submits suboptimal Queries like
SELECT * FROM phpgw_accounts WHERE account_id=''
Now Postgresql responds like this:
*PostgreSQL Error*: 1 (ERROR: pg_atoi: zero-length string )
Is there a workaround for this (eg. a Startup-Parameter that can be set)?
If anybody else has got troubles with this Application: I guess I have a Workaround with is not too hard. In the file $INSTALL_DIR/phpgwapi/inc/class.db_pgsql.inc.php change the function query, so that it looks like this:
/* Postgres chokes on Queries like WHERE id='' */
$Query_String = str_replace("''","'0'",$Query_String);$this->Query_ID = @pg_Exec($this->Link_ID, $Query_String);
In other words: right before phpgroupware does a call to pg_Exec, I replace any '' by '0' which causes Postgres to behave properly. Thanks to Oli and Jon Pastore for ginving me the crucial hints.
Regards, Dani
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
