From c97e8deb3ad3b475f933b51a960af9266db35bb3 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Sun, 25 May 2008 02:38:30 +0000
Subject: [PATCH] Changed postgresql sequence fetching to GetID. MDL-7183

---
 lib/dml/postgres7_adodb_moodle_database.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/lib/dml/postgres7_adodb_moodle_database.php b/lib/dml/postgres7_adodb_moodle_database.php
index a2f8ab36a3..6ce794e702 100644
--- a/lib/dml/postgres7_adodb_moodle_database.php
+++ b/lib/dml/postgres7_adodb_moodle_database.php
@@ -151,6 +151,7 @@ class postgres7_adodb_moodle_database extends adodb_moodle_database {
 
     /**
      * Insert new record into database, as fast as possible, no safety checks, lobs not supported.
+     * (overloaded from adodb_moodle_database because of sequence numbers
      * @param string $table name
      * @param mixed $params data record as object or array
      * @param bool $returnit return it of inserted record
@@ -169,7 +170,8 @@ class postgres7_adodb_moodle_database extends adodb_moodle_database {
         }
         unset($params['id']);
         if ($returnid) {
-            if ($nextval = $this->get_field_sql("SELECT NEXTVAL('{$this->prefix}{$table}_id_seq')")) {
+            $seqname = "{$this->prefix}{$table}_id_seq";
+            if ($nextval = $this->db->GenID($seqname)) {
                 $params['id'] = (int)$nextval;
             }
         }
-- 
2.39.5