X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F20%2Fupdate_buffer_lastseen.sql;h=14e5c58d11d931aa28128cfa5b7bb9cd4e67438b;hp=55415050908c2e5a800fda8d94a7ac52775a2de3;hb=5e3bcda8c341dbe6846d4723afe7096acca8f304;hpb=d682289cc69fac3a5776ef29059cc1f54d8d37d4

diff --git a/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql b/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
index 55415050..14e5c58d 100644
--- a/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
+++ b/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
@@ -1,3 +1,3 @@
 UPDATE buffer
-SET lastseenmsgid = :lastseenmsgid
+SET lastseenmsgid = least(:lastseenmsgid, buffer.lastmsgid)
 WHERE userid = :userid AND bufferid = :bufferid