From 6db368e1171ba1f9f9e9c80acb38f72c00219461 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 4 Sep 2007 17:51:51 +0000
Subject: [PATCH] PostgreSQL doesn't like aliases in update statements.
 Changing to the whole name as prefix.

---
 lib/db/upgradelib.php | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/lib/db/upgradelib.php b/lib/db/upgradelib.php
index afe0cd1d7a..5e9542c1ce 100644
--- a/lib/db/upgradelib.php
+++ b/lib/db/upgradelib.php
@@ -320,21 +320,21 @@ function upgrade_18_groups() {
 
 /// Transfer courseid from 'mdl_groups_courses_groups' to 'mdl_groups'.
     if ($result) {
-        $sql = "UPDATE {$CFG->prefix}groups g
+        $sql = "UPDATE {$CFG->prefix}groups
                    SET courseid = (
                         SELECT MAX(courseid)
                           FROM {$CFG->prefix}groups_courses_groups gcg
-                         WHERE gcg.groupid = g.id)";
+                         WHERE gcg.groupid = {$CFG->prefix}groups.id)";
         execute_sql($sql);
     }
 
 /// Transfer courseid from 'groups_courses_groupings' to 'mdl_groupings'.
     if ($result) {
-        $sql = "UPDATE {$CFG->prefix}groupings g
+        $sql = "UPDATE {$CFG->prefix}groupings
                    SET courseid = (
                         SELECT MAX(courseid)
                           FROM {$CFG->prefix}groups_courses_groupings gcg
-                         WHERE gcg.groupingid = g.id)";
+                         WHERE gcg.groupingid = {$CFG->prefix}groupings.id)";
         execute_sql($sql);
     }
 
-- 
2.39.5