create or replace function pgq.current_event_table(x_queue_name text) returns text as $$ -- ---------------------------------------------------------------------- -- Function: pgq.current_event_table(1) -- -- Return active event table for particular queue. -- -- Note: -- The result is valid only during current transaction. -- -- Parameters: -- x_queue_name - Queue name. -- ---------------------------------------------------------------------- declare res text; begin select queue_data_pfx || '_' || queue_cur_table into res from pgq.queue where queue_name = x_queue_name; if not found then raise exception 'Event queue not found'; end if; return res; end; $$ language plpgsql; -- no perms needed