]> git.mjollnir.org Git - moodle.git/commit
projects / moodle.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 932bba0) | patch
MDL-17492 Reset flag did not work in PostgreSQL. Merged from 1.9
authormudrd8mz <mudrd8mz>
Mon, 2 Mar 2009 21:45:08 +0000 (21:45 +0000)
committermudrd8mz <mudrd8mz>
Mon, 2 Mar 2009 21:45:08 +0000 (21:45 +0000)
commitcef530456291aa56bd506d1abd25b10df0d3b6f5
tree7b950d5ada910e321560116a014dccf5eed54be1tree | snapshot
parent932bba0197e33957269e906ee3193d68cc978506commit | diff
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 diff | blob | history
Unnamed repository; edit this file to name it for gitweb.