[eluser]xoRiZ[/eluser]
Just thought I would mention that it would be useful to change the search path in a query ran, incase you're not using the default schema.
To resolve the problem I ran into I simply modified this function in my DB_driver.php
Code:
function simple_query($sql)
{
if ( ! $this->conn_id)
{
$this->initialize();
}
if ($this->dbdriver=='postgre') { $sql = 'SET search_path TO '.$this->database.', public; '.$sql; }
return $this->_execute($sql);
}
Maybe there's an alternate method?