From d55132a76912d9e478cc0cb03ebce07aad7da5ad Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Mon, 24 Nov 2008 11:58:59 +0000
Subject: [PATCH] MDL-17378 DML: fixed pg < 8.3 regression - found by sam,
 thanks

---
 lib/dml/pgsql_native_moodle_database.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/dml/pgsql_native_moodle_database.php b/lib/dml/pgsql_native_moodle_database.php
index 6aaef062ff..b903599148 100644
--- a/lib/dml/pgsql_native_moodle_database.php
+++ b/lib/dml/pgsql_native_moodle_database.php
@@ -674,7 +674,7 @@ class pgsql_native_moodle_database extends moodle_database {
                     unset($params['id']);
                 } else {
                     //ugly workaround for pg < 8.2
-                    $seqsql = "SELECT NEXTVAL({$this->prefix}{$table}_id_seq) AS id";
+                    $seqsql = "SELECT NEXTVAL('{$this->prefix}{$table}_id_seq') AS id";
                     $this->query_start($seqsql, NULL, SQL_QUERY_AUX);
                     $result = pg_query($this->pgsql, $seqsql);
                     $this->query_end($result);
-- 
2.39.5