Welcome Guest, Not a member yet? Register   Sign In
PostgreSQL And the DB Driver

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

function simple_query($sql)
        if ( ! $this->conn_id)
        if ($this->dbdriver=='postgre') { $sql = 'SET search_path TO '.$this->database.', public; '.$sql; }
        return $this->_execute($sql);

Maybe there's an alternate method?

I suppose there isn't.. Would be much more beneficial if I was able to just set the database (schema), and it would prefix all of the tables automatically.

Theme © iAndrew 2016 - Forum software by © MyBB