pgq_node.register_location: skip insert if location is null

This allows tag-dead for non-existing node.

1 files changed, 1 insertions, 1 deletions

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;