search

pgq / pgq-node

Cascaded Queueing on top of PgQ
4 stars 3 forks source link

Catch extra CONTEXT line in pgq_node_test.out #2

Closed df7cb closed 5 years ago

df7cb commented 5 years ago

Net diff from pgq_node_test.out to pgq_node_test_1.out:

--- expected/pgq_node_test.out  2019-09-17 13:49:24.357680604 +0200
+++ expected/pgq_node_test_1.out    2019-09-17 13:50:05.293667964 +0200
@@ -269,6 +269,7 @@

 select * from pgq_node.is_root_node('cqueue');
 ERROR:  queue does not exist: cqueue
+CONTEXT:  PL/pgSQL function pgq_node.is_root_node(text) line 19 at RAISE
 select * from pgq_node.get_consumer_state('bqueue', 'random_consumer');
  ret_code | ret_note | node_type | node_name | completed_tick | provider_node | provider_location | paused | uptodate | cur_error
 ----------+----------+-----------+-----------+----------------+---------------+-------------------+--------+----------+-----------

Necessary on PG11+.

markokr commented 5 years ago

Thanks for submitting.

I found better solution - just set verbosity=terse, this way there is no need to alt file.