X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fversion%2F20%2Fupgrade_001_add_function_populate_lastmsgid.sql;h=79c82a95eab8e92a1cb584859979f954733057b2;hp=561422abc80437f96ad3744b2586f9491fe9162b;hb=f509a0d1065d4e42c9eb84e0ffab9e72517df04c;hpb=0260fbe00ddbd1ce78b1870f40fce969b8f34ee5

diff --git a/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql b/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql
index 561422ab..79c82a95 100644
--- a/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql
+++ b/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql
@@ -5,12 +5,12 @@ BEGIN
 	FOR i IN SELECT * FROM buffer
 	LOOP
 		UPDATE buffer
-			SET lastmsgid = (
+			SET lastmsgid = COALESCE((
 				SELECT backlog.messageid
 				FROM backlog
 				WHERE backlog.bufferid = i.bufferid
 				ORDER BY messageid DESC LIMIT 1
-			)
+			), 0)
 			WHERE buffer.bufferid = i.bufferid;
 	END LOOP;
 	RETURN;