From 2f7196f1b83ee167372250d445d1e403dadc8c36 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Mon, 14 Nov 2011 12:43:47 +0200 Subject: [PATCH] pgq_node.register_location: skip insert if location is null This allows tag-dead for non-existing node. --- sql/pgq_node/functions/pgq_node.register_location.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/pgq_node/functions/pgq_node.register_location.sql b/sql/pgq_node/functions/pgq_node.register_location.sql index aee290f7..ea11e953 100644 --- a/sql/pgq_node/functions/pgq_node.register_location.sql +++ b/sql/pgq_node/functions/pgq_node.register_location.sql @@ -42,7 +42,7 @@ begin dead = i_dead where queue_name = i_queue_name and node_name = i_node_name; - else + elsif i_node_location is not null then insert into pgq_node.node_location (queue_name, node_name, node_location, dead) values (i_queue_name, i_node_name, i_node_location, i_dead); end if; -- 2.39.5