diff options
| author | Priit Kustala | 2009-04-28 10:25:38 +0000 |
|---|---|---|
| committer | Marko Kreen | 2009-04-28 11:58:52 +0000 |
| commit | d92a50005f33120981b9e9d0b4a77c234758adfc (patch) | |
| tree | a4a7761bb263646f099c4115a8853547f6196eb6 | |
| parent | 7cde7f93a654d996553c0c521dbbba49364cd2d4 (diff) | |
Decrease log level in pgq_node.get_node_info.sql and pgq_node.get_consumer_state.sql
| -rw-r--r-- | sql/pgq_node/functions/pgq_node.get_consumer_state.sql | 2 | ||||
| -rw-r--r-- | sql/pgq_node/functions/pgq_node.get_node_info.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sql/pgq_node/functions/pgq_node.get_consumer_state.sql b/sql/pgq_node/functions/pgq_node.get_consumer_state.sql index 548fed96..389d985a 100644 --- a/sql/pgq_node/functions/pgq_node.get_consumer_state.sql +++ b/sql/pgq_node/functions/pgq_node.get_consumer_state.sql @@ -33,7 +33,7 @@ create or replace function pgq_node.get_consumer_state( -- uptodate - if consumer has loaded last changes -- ---------------------------------------------------------------------- begin - select 200, 'Ok', n.node_type, n.node_name, s.last_tick_id, + select 100, 'Ok', n.node_type, n.node_name, s.last_tick_id, s.provider_node, p.node_location, s.paused, s.uptodate into ret_code, ret_note, node_type, node_name, completed_tick, provider_node, provider_location, paused, uptodate diff --git a/sql/pgq_node/functions/pgq_node.get_node_info.sql b/sql/pgq_node/functions/pgq_node.get_node_info.sql index 60719576..20978762 100644 --- a/sql/pgq_node/functions/pgq_node.get_node_info.sql +++ b/sql/pgq_node/functions/pgq_node.get_node_info.sql @@ -44,7 +44,7 @@ create or replace function pgq_node.get_node_info( declare sql text; begin - select 200, 'Ok', n.node_type, n.node_name, g.last_tick, + select 100, 'Ok', n.node_type, n.node_name, g.last_tick, c.node_type, c.queue_name, w.provider_node, l.node_location, n.worker_name, w.paused, w.uptodate, w.last_tick_id into ret_code, ret_note, node_type, node_name, global_watermark, |