Changeset 331:7b0a879d0dee for inc/core/class.dc.core.php

Timestamp:

06/02/11 18:46:03 (14 years ago)

Author:

xave

Branch:

default

Message:

Now handles non default postgres schemas.

Enter schema name in the database prefix using a period as separator: 'schema.prefix'

File:

• inc/core/class.dc.core.php (modified) (1 diff)

inc/core/class.dc.core.php

@@ -63 +63 @@
           if ($this->con instanceof mysqlConnection) {
                mysqlConnection::$weak_locks = true;
+          }
+          
+          # define searchpath for postgresql
+          if ($this->con instanceof pgsqlConnection)
+          {
+               $searchpath = explode ('.',$prefix,2);
+               if (count($searchpath) > 1)
+               {
+                    $prefix = $searchpath[1];
+                    $sql = 'SET search_path TO '.$searchpath[0].',public;';
+                    $this->con->execute($sql);
+               }
           }