From b337cac2e89af9fadb81ee22d375d95bf24cf665 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 12 Oct 2010 15:32:23 +0300 Subject: [PATCH] londiste.root_check_seqs: lock node row --- sql/londiste/functions/londiste.root_check_seqs.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sql/londiste/functions/londiste.root_check_seqs.sql b/sql/londiste/functions/londiste.root_check_seqs.sql index 6170ff02..15230939 100644 --- a/sql/londiste/functions/londiste.root_check_seqs.sql +++ b/sql/londiste/functions/londiste.root_check_seqs.sql @@ -32,7 +32,8 @@ begin select node_type, node_name into n from pgq_node.node_info - where queue_name = i_queue_name; + where queue_name = i_queue_name + for update; if not found then select 404, 'Queue not found: ' || i_queue_name into ret_code, ret_note; return; -- 2.39.5