From cef530456291aa56bd506d1abd25b10df0d3b6f5 Mon Sep 17 00:00:00 2001
From: mudrd8mz <mudrd8mz>
Date: Mon, 2 Mar 2009 21:45:08 +0000
Subject: [PATCH] MDL-17492 Reset flag did not work in PostgreSQL. Merged from
 1.9

Postgres does not seem to support table alias in UPDATE statement.
Therefore the SQL like
 UPDATE mdl_tag tg SET tg.flag = 0, tg.timemodified = 1236027984 WHERE tg.id IN (4)
ends with an ERROR: column "tg" of relation "mdl_tag" does not exist
The fix is quite easy - just do not use table alias as it makes no sense
here anyway.
---
 tag/lib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/tag/lib.php b/tag/lib.php
index 5c6229d3a9..e5f1ac1ea2 100644
--- a/tag/lib.php
+++ b/tag/lib.php
@@ -1026,7 +1026,7 @@ function tag_unset_flag($tagids) {
         $tagids = implode(',', $tagids);
     }
     $timemodified = time();
-    return $DB->execute("UPDATE {tag} tg SET tg.flag = 0, tg.timemodified = ? WHERE tg.id IN ($tagids)", array($timemodified));
+    return $DB->execute("UPDATE {tag} SET flag = 0, timemodified = ? WHERE id IN ($tagids)", array($timemodified));
 }
 
 ?>
-- 
2.39.5