/usr/share/doc/postgresql-10-pgq3/html/index/Functions.html is in postgresql-10-pgq3 3.2.6-7.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Function Index - PgQ</title><link rel="stylesheet" type="text/css" href="../styles/main.css"><script language=JavaScript src="../javascript/main.js"></script><script language=JavaScript src="../javascript/searchdata.js"></script></head><body class="IndexPage" onLoad="NDOnLoad()"><script language=JavaScript><!--
if (browserType) {document.write("<div class=" + browserType + ">");if (browserVer) {document.write("<div class=" + browserVer + ">"); }}// --></script>
<!-- Generated by Natural Docs, version 1.51 -->
<!-- http://www.naturaldocs.org -->
<!-- saved from url=(0026)http://www.naturaldocs.org -->
<div id=Index><div class=IPageTitle>Function Index</div><div class=INavigationBar>$#! · 0-9 · A · <a href="#B">B</a> · <a href="#C">C</a> · <a href="#D">D</a> · <a href="#E">E</a> · <a href="#F">F</a> · <a href="#G">G</a> · H · <a href="#I">I</a> · <a href="#J">J</a> · K · <a href="#L">L</a> · <a href="Functions2.html#M">M</a> · <a href="Functions2.html#N">N</a> · O · P · <a href="Functions2.html#Q">Q</a> · <a href="Functions2.html#R">R</a> · <a href="Functions2.html#S">S</a> · <a href="Functions2.html#T">T</a> · <a href="Functions2.html#U">U</a> · <a href="Functions2.html#V">V</a> · W · X · Y · Z</div><table border=0 cellspacing=0 cellpadding=0><tr><td class=IHeading id=IFirstHeading><a name="B"></a>B</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.batch_event_sql(1)" id=link1 onMouseOver="ShowTip(event, 'tt1', 'link1')" onMouseOut="HideTip('tt1')" class=ISymbol>batch_event_sql(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.batch_event_tables(1)" id=link2 onMouseOver="ShowTip(event, 'tt2', 'link2')" onMouseOut="HideTip('tt2')" class=ISymbol>batch_event_tables(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.batch_retry(2)" id=link3 onMouseOver="ShowTip(event, 'tt3', 'link3')" onMouseOut="HideTip('tt3')" class=ISymbol>batch_retry(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="C"></a>C</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.create_queue(1)" id=link4 onMouseOver="ShowTip(event, 'tt4', 'link4')" onMouseOut="HideTip('tt4')" class=ISymbol>create_queue(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.current_event_table(1)" id=link5 onMouseOver="ShowTip(event, 'tt5', 'link5')" onMouseOut="HideTip('tt5')" class=ISymbol>current_event_table(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="D"></a>D</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.drop_queue(1)" id=link6 onMouseOver="ShowTip(event, 'tt6', 'link6')" onMouseOut="HideTip('tt6')" class=ISymbol>drop_queue(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.drop_queue(2)" id=link7 onMouseOver="ShowTip(event, 'tt7', 'link7')" onMouseOut="HideTip('tt7')" class=ISymbol>drop_queue(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="E"></a>E</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.event_retry(3a)" id=link8 onMouseOver="ShowTip(event, 'tt8', 'link8')" onMouseOut="HideTip('tt8')" class=ISymbol>event_retry(3a)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.event_retry(3b)" id=link9 onMouseOver="ShowTip(event, 'tt9', 'link9')" onMouseOut="HideTip('tt9')" class=ISymbol>event_retry(3b)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.event_retry_raw(12)" id=link10 onMouseOver="ShowTip(event, 'tt10', 'link10')" onMouseOut="HideTip('tt10')" class=ISymbol>event_retry_raw(12)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="F"></a>F</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.find_tick_helper(6)" id=link11 onMouseOver="ShowTip(event, 'tt11', 'link11')" onMouseOut="HideTip('tt11')" class=ISymbol>find_tick_helper(6)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.finish_batch(1)" id=link12 onMouseOver="ShowTip(event, 'tt12', 'link12')" onMouseOut="HideTip('tt12')" class=ISymbol>finish_batch(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.force_tick(2)" id=link13 onMouseOver="ShowTip(event, 'tt13', 'link13')" onMouseOut="HideTip('tt13')" class=ISymbol>force_tick(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="G"></a>G</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_batch_cursor(3)" id=link14 onMouseOver="ShowTip(event, 'tt14', 'link14')" onMouseOut="HideTip('tt14')" class=ISymbol>get_batch_cursor(3)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_batch_cursor(4)" id=link15 onMouseOver="ShowTip(event, 'tt15', 'link15')" onMouseOut="HideTip('tt15')" class=ISymbol>get_batch_cursor(4)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_batch_events(1)" id=link16 onMouseOver="ShowTip(event, 'tt16', 'link16')" onMouseOut="HideTip('tt16')" class=ISymbol>get_batch_events(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_batch_info(1)" id=link17 onMouseOver="ShowTip(event, 'tt17', 'link17')" onMouseOut="HideTip('tt17')" class=ISymbol>get_batch_info(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_consumer_info(0)" id=link18 onMouseOver="ShowTip(event, 'tt18', 'link18')" onMouseOut="HideTip('tt18')" class=ISymbol>get_consumer_info(0)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_consumer_info(1)" id=link19 onMouseOver="ShowTip(event, 'tt19', 'link19')" onMouseOut="HideTip('tt19')" class=ISymbol>get_consumer_info(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_consumer_info(2)" id=link20 onMouseOver="ShowTip(event, 'tt20', 'link20')" onMouseOut="HideTip('tt20')" class=ISymbol>get_consumer_info(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_queue_info(0)" id=link21 onMouseOver="ShowTip(event, 'tt21', 'link21')" onMouseOut="HideTip('tt21')" class=ISymbol>get_queue_info(0)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.get_queue_info(1)" id=link22 onMouseOver="ShowTip(event, 'tt22', 'link22')" onMouseOut="HideTip('tt22')" class=ISymbol>get_queue_info(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.grant_perms(1)" id=link23 onMouseOver="ShowTip(event, 'tt23', 'link23')" onMouseOut="HideTip('tt23')" class=ISymbol>grant_perms(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.grant_perms_from(1)" id=link24 onMouseOver="ShowTip(event, 'tt24', 'link24')" onMouseOut="HideTip('tt24')" class=ISymbol>grant_perms_from(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="I"></a>I</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.insert_event(3)" id=link25 onMouseOver="ShowTip(event, 'tt25', 'link25')" onMouseOut="HideTip('tt25')" class=ISymbol>insert_event(3)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.insert_event(7)" id=link26 onMouseOver="ShowTip(event, 'tt26', 'link26')" onMouseOut="HideTip('tt26')" class=ISymbol>insert_event(7)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="J"></a>J</td><td></td></tr><tr><td class=ISymbolPrefix id=IOnlySymbolPrefix> </td><td class=IEntry><a href="../files/triggers-sql.html#pgq.jsontriga" id=link27 onMouseOver="ShowTip(event, 'tt27', 'link27')" onMouseOut="HideTip('tt27')" class=ISymbol>jsontriga</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="L"></a>L</td><td></td></tr><tr><td class=ISymbolPrefix id=IOnlySymbolPrefix> </td><td class=IEntry><a href="../files/triggers-sql.html#pgq.logutriga" id=link28 onMouseOver="ShowTip(event, 'tt28', 'link28')" onMouseOut="HideTip('tt28')" class=ISymbol>logutriga</a>, <span class=IParent>pgq</span></td></tr></table>
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt1"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.batch_event_sql(</td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns text</td></tr></table></td></tr></table></blockquote>Creates SELECT statement that fetches events for this batch.</div></div><div class=CToolTip id="tt2"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.batch_event_tables(</td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns setof text</td></tr></table></td></tr></table></blockquote>Returns set of table names where this batch events may reside.</div></div><div class=CToolTip id="tt3"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.batch_retry(</td><td class="PType prettyprint " nowrap>i_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>i_retry_seconds </td><td class="PParameter prettyprint " nowrap>integer</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Put whole batch into retry queue, to be processed again later.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt4"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.create_queue(</td><td class="PType prettyprint " nowrap>i_queue_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Creates new queue with given name.</div></div><div class=CToolTip id="tt5"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.current_event_table(</td><td class="PType prettyprint " nowrap>x_queue_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns text</td></tr></table></td></tr></table></blockquote>Return active event table for particular queue. </div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt6"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.drop_queue(</td><td class="PType prettyprint " nowrap>x_queue_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Drop queue and all associated tables. </div></div><div class=CToolTip id="tt7"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.drop_queue(</td><td class="PType prettyprint " nowrap>x_queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_force </td><td class="PParameter prettyprint " nowrap>bool</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Drop queue and all associated tables.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt8"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.event_retry(</td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_event_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_retry_time </td><td class="PParameter prettyprint " nowrap>timestamptz</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Put the event into retry queue, to be processed again later.</div></div><div class=CToolTip id="tt9"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.event_retry(</td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_event_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_retry_seconds </td><td class="PParameter prettyprint " nowrap>integer</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Put the event into retry queue, to be processed later again.</div></div><div class=CToolTip id="tt10"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.event_retry_raw(</td><td class="PType prettyprint " nowrap>x_queue </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_consumer </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_retry_after </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_retry </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_type </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_data </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_extra1 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_extra2 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_extra3 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_ev_extra4 </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>Allows full control over what goes to retry queue.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt11"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.find_tick_helper(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_queue_id </td><td class="PParameter prettyprint " nowrap>int4,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_prev_tick_id </td><td class="PParameter prettyprint " nowrap>int8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_prev_tick_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_prev_tick_seq </td><td class="PParameter prettyprint " nowrap>int8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_min_count </td><td class="PParameter prettyprint " nowrap>int8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_min_interval </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>next_tick_id </td><td class="PParameter prettyprint " nowrap>int8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>next_tick_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>next_tick_seq </td><td class="PParameter prettyprint " nowrap>int8</td><td class="PAfterParameters prettyprint "nowrap>) as</td></tr></table></td></tr></table></blockquote>Helper function for pgq.next_batch_custom() to do extended tick search.</div></div><div class=CToolTip id="tt12"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.finish_batch(</td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Closes a batch. </div></div><div class=CToolTip id="tt13"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.force_tick(</td><td class="PType prettyprint " nowrap>i_queue_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>Simulate lots of events happening to force ticker to tick.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt14"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_batch_cursor(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_cursor_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_quick_limit </td><td class="PParameter prettyprint " nowrap>int4,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_txid </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_retry </td><td class="PParameter prettyprint " nowrap>int4,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_type </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_data </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra1 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra2 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra3 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra4 </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Get events in batch using a cursor.</div></div><div class=CToolTip id="tt15"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_batch_cursor(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_cursor_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_quick_limit </td><td class="PParameter prettyprint " nowrap>int4,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_extra_where </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_txid </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_retry </td><td class="PParameter prettyprint " nowrap>int4,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_type </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_data </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra1 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra2 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra3 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra4 </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Get events in batch using a cursor.</div></div><div class=CToolTip id="tt16"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_batch_events(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_txid </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_retry </td><td class="PParameter prettyprint " nowrap>int4,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_type </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_data </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra1 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra2 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra3 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_extra4 </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Get all events in batch.</div></div><div class=CToolTip id="tt17"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_batch_info(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>x_batch_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>consumer_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>batch_start </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>batch_end </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>prev_tick_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>tick_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>seq_start </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>seq_end </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) as</td></tr></table></td></tr></table></blockquote>Returns detailed info about a batch.</div></div><div class=CToolTip id="tt18"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_consumer_info(</td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>consumer_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_seen </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_tick </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>current_batch </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>next_tick </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>pending_events </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Returns info about all consumers on all queues.</div></div><div class=CToolTip id="tt19"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_consumer_info(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>consumer_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_seen </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_tick </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>current_batch </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>next_tick </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>pending_events </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Returns info about all consumers on single queue.</div></div><div class=CToolTip id="tt20"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_consumer_info(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_consumer_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>consumer_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_seen </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_tick </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>current_batch </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>next_tick </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>pending_events </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Get info about particular consumer on particular queue.</div></div><div class=CToolTip id="tt21"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_queue_info(</td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ntables </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_cur_table </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_rotation_period </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_switch_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_external_ticker </td><td class="PParameter prettyprint " nowrap>boolean,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_paused </td><td class="PParameter prettyprint " nowrap>boolean,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_max_count </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_max_lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_idle_period </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ticker_lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_per_sec </td><td class="PParameter prettyprint " nowrap>float8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_new </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_tick_id </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Get info about all queues.</div></div><div class=CToolTip id="tt22"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.get_queue_info(</td><td class="PTypePrefix prettyprint " nowrap>in </td><td class="PType prettyprint " nowrap>i_queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ntables </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_cur_table </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_rotation_period </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_switch_time </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_external_ticker </td><td class="PParameter prettyprint " nowrap>boolean,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_paused </td><td class="PParameter prettyprint " nowrap>boolean,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_max_count </td><td class="PParameter prettyprint " nowrap>integer,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_max_lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>queue_ticker_idle_period </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ticker_lag </td><td class="PParameter prettyprint " nowrap>interval,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_per_sec </td><td class="PParameter prettyprint " nowrap>float8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>ev_new </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>last_tick_id </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Get info about particular queue.</div></div><div class=CToolTip id="tt23"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.grant_perms(</td><td class="PType prettyprint " nowrap>x_queue_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Make event tables readable by public.</div></div><div class=CToolTip id="tt24"><div class=CFunction>Copy grants from one table to another. </div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt25"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.insert_event(</td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_type </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_data </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>Insert a event into queue.</div></div><div class=CToolTip id="tt26"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td><table border=0 cellspacing=0 cellpadding=0><tr><td class="PBeforeParameters prettyprint "nowrap>pgq.insert_event(</td><td class="PType prettyprint " nowrap>queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_type </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_data </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_extra1 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_extra2 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_extra3 </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>ev_extra4 </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>Insert a event into queue with all the extra fields.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt27"><div class=CFunction>Trigger function that puts row data in JSON-encoded form into queue.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt28"><div class=CFunction>Trigger function that puts row data in urlencoded form into queue.</div></div><!--END_ND_TOOLTIPS-->
</div><!--Index-->
<div id=Footer><a href="http://www.naturaldocs.org">Generated by Natural Docs</a></div><!--Footer-->
<div id=Menu><div class=MTitle>PgQ<div class=MSubTitle>Database API</div></div><div class=MEntry><div class=MFile><a href="../files/external-sql.html">Public Functions</a></div></div><div class=MEntry><div class=MFile><a href="../files/triggers-sql.html">Public Triggers</a></div></div><div class=MEntry><div class=MFile><a href="../files/internal-sql.html">Internal Functions</a></div></div><div class=MEntry><div class=MFile><a href="../files/schema-sql.html">Internal Tables</a></div></div><div class=MEntry><div class=MGroup><a href="javascript:ToggleMenu('MGroupContent1')">Index</a><div class=MGroupContent id=MGroupContent1><div class=MEntry><div class=MIndex><a href="General.html">Everything</a></div></div><div class=MEntry><div class=MIndex><a href="DatabaseTables.html">Database Tables</a></div></div><div class=MEntry><div class=MIndex id=MSelected>Functions</div></div></div></div></div><script type="text/javascript"><!--
var searchPanel = new SearchPanel("searchPanel", "HTML", "../search");
--></script><div id=MSearchPanel class=MSearchPanelInactive><input type=text id=MSearchField value=Search onFocus="searchPanel.OnSearchFieldFocus(true)" onBlur="searchPanel.OnSearchFieldFocus(false)" onKeyUp="searchPanel.OnSearchFieldChange()"><select id=MSearchType onFocus="searchPanel.OnSearchTypeFocus(true)" onBlur="searchPanel.OnSearchTypeFocus(false)" onChange="searchPanel.OnSearchTypeChange()"><option id=MSearchEverything selected value="General">Everything</option><option value="DatabaseTables">Database Tables</option><option value="Functions">Functions</option></select></div></div><!--Menu-->
<div id=MSearchResultsWindow><iframe src="" frameborder=0 name=MSearchResults id=MSearchResults></iframe><a href="javascript:searchPanel.CloseResultsWindow()" id=MSearchResultsWindowClose>Close</a></div>
<script language=JavaScript><!--
if (browserType) {if (browserVer) {document.write("</div>"); }document.write("</div>");}// --></script></body></html>
|