From 1433162ce048db193e686577169313755ecc477e Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Mon, 4 May 2009 13:31:02 +0300 Subject: [PATCH] pgq.register_consumer_at(): update last seen timestamp on position move --- sql/pgq/functions/pgq.register_consumer.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sql/pgq/functions/pgq.register_consumer.sql b/sql/pgq/functions/pgq.register_consumer.sql index 8cbbe8e2..45d7a5e2 100644 --- a/sql/pgq/functions/pgq.register_consumer.sql +++ b/sql/pgq/functions/pgq.register_consumer.sql @@ -88,7 +88,8 @@ begin end if; -- update tick pos if requested update pgq.subscription - set sub_last_tick = x_tick_pos + set sub_last_tick = x_tick_pos, + sub_active = now() where sub_consumer = x_consumer_id and sub_queue = x_queue_id; end if; -- 2.39.5