/usr/share/doc/postgresql-10-pgq3/html/index/Functions2.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 | <!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="Functions.html#B">B</a> · <a href="Functions.html#C">C</a> · <a href="Functions.html#D">D</a> · <a href="Functions.html#E">E</a> · <a href="Functions.html#F">F</a> · <a href="Functions.html#G">G</a> · H · <a href="Functions.html#I">I</a> · <a href="Functions.html#J">J</a> · K · <a href="Functions.html#L">L</a> · <a href="#M">M</a> · <a href="#N">N</a> · O · P · <a href="#Q">Q</a> · <a href="#R">R</a> · <a href="#S">S</a> · <a href="#T">T</a> · <a href="#U">U</a> · <a href="#V">V</a> · W · X · Y · Z</div><table border=0 cellspacing=0 cellpadding=0><tr><td class=IHeading id=IFirstHeading><a name="M"></a>M</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.maint_operations(0)" id=link29 onMouseOver="ShowTip(event, 'tt29', 'link29')" onMouseOut="HideTip('tt29')" class=ISymbol>maint_operations(0)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.maint_retry_events(0)" id=link30 onMouseOver="ShowTip(event, 'tt30', 'link30')" onMouseOut="HideTip('tt30')" class=ISymbol>maint_retry_events(0)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.maint_rotate_tables_step1(1)" id=link31 onMouseOver="ShowTip(event, 'tt31', 'link31')" onMouseOut="HideTip('tt31')" class=ISymbol>maint_rotate_tables_step1(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.maint_rotate_tables_step2(0)" id=link32 onMouseOver="ShowTip(event, 'tt32', 'link32')" onMouseOut="HideTip('tt32')" class=ISymbol>maint_rotate_tables_step2(0)</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.maint_tables_to_vacuum(0)" id=link33 onMouseOver="ShowTip(event, 'tt33', 'link33')" onMouseOut="HideTip('tt33')" class=ISymbol>maint_tables_to_vacuum(0)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="N"></a>N</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.next_batch(2)" id=link34 onMouseOver="ShowTip(event, 'tt34', 'link34')" onMouseOut="HideTip('tt34')" class=ISymbol>next_batch(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.next_batch_custom(5)" id=link35 onMouseOver="ShowTip(event, 'tt35', 'link35')" onMouseOut="HideTip('tt35')" class=ISymbol>next_batch_custom(5)</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.next_batch_info(2)" id=link36 onMouseOver="ShowTip(event, 'tt36', 'link36')" onMouseOut="HideTip('tt36')" class=ISymbol>next_batch_info(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="Q"></a>Q</td><td></td></tr><tr><td class=ISymbolPrefix id=IOnlySymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.quote_fqname(1)" id=link37 onMouseOver="ShowTip(event, 'tt37', 'link37')" onMouseOut="HideTip('tt37')" class=ISymbol>quote_fqname(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="R"></a>R</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.register_consumer(2)" id=link38 onMouseOver="ShowTip(event, 'tt38', 'link38')" onMouseOut="HideTip('tt38')" class=ISymbol>register_consumer(2)</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.register_consumer_at(3)" id=link39 onMouseOver="ShowTip(event, 'tt39', 'link39')" onMouseOut="HideTip('tt39')" class=ISymbol>register_consumer_at(3)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="S"></a>S</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.seq_getval(1)" id=link40 onMouseOver="ShowTip(event, 'tt40', 'link40')" onMouseOut="HideTip('tt40')" class=ISymbol>seq_getval(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.seq_setval(2)" id=link41 onMouseOver="ShowTip(event, 'tt41', 'link41')" onMouseOut="HideTip('tt41')" class=ISymbol>seq_setval(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.set_queue_config(3)" id=link42 onMouseOver="ShowTip(event, 'tt42', 'link42')" onMouseOut="HideTip('tt42')" class=ISymbol>set_queue_config(3)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix id=ILastSymbolPrefix> </td><td class=IEntry><a href="../files/triggers-sql.html#pgq.sqltriga" id=link43 onMouseOver="ShowTip(event, 'tt43', 'link43')" onMouseOut="HideTip('tt43')" class=ISymbol>sqltriga</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="T"></a>T</td><td></td></tr><tr><td class=ISymbolPrefix id=IFirstSymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.ticker(0)" id=link44 onMouseOver="ShowTip(event, 'tt44', 'link44')" onMouseOut="HideTip('tt44')" class=ISymbol>ticker(0)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.ticker(1)" id=link45 onMouseOver="ShowTip(event, 'tt45', 'link45')" onMouseOut="HideTip('tt45')" class=ISymbol>ticker(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=ISymbolPrefix> </td><td class=IEntry><a href="../files/internal-sql.html#pgq.ticker(3)" id=link46 onMouseOver="ShowTip(event, 'tt46', 'link46')" onMouseOut="HideTip('tt46')" class=ISymbol>ticker(3)</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.tune_storage(1)" id=link47 onMouseOver="ShowTip(event, 'tt47', 'link47')" onMouseOut="HideTip('tt47')" class=ISymbol>tune_storage(1)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="U"></a>U</td><td></td></tr><tr><td class=ISymbolPrefix id=IOnlySymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.unregister_consumer(2)" id=link48 onMouseOver="ShowTip(event, 'tt48', 'link48')" onMouseOut="HideTip('tt48')" class=ISymbol>unregister_consumer(2)</a>, <span class=IParent>pgq</span></td></tr><tr><td class=IHeading><a name="V"></a>V</td><td></td></tr><tr><td class=ISymbolPrefix id=IOnlySymbolPrefix> </td><td class=IEntry><a href="../files/external-sql.html#pgq.version(0)" id=link49 onMouseOver="ShowTip(event, 'tt49', 'link49')" onMouseOut="HideTip('tt49')" class=ISymbol>version(0)</a>, <span class=IParent>pgq</span></td></tr></table>
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt29"><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.maint_operations(</td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>func_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>func_arg </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns setof record</td></tr></table></td></tr></table></blockquote>Returns list of functions to call for maintenance.</div></div><div class=CToolTip id="tt30"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td class="prettyprint">pgq.maint_retry_events() returns integer</td></tr></table></blockquote>Moves retry events back to main queue.</div></div><div class=CToolTip id="tt31"><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.maint_rotate_tables_step1(</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>Rotate tables for one queue.</div></div><div class=CToolTip id="tt32"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td class="prettyprint">pgq.maint_rotate_tables_step2() returns integer</td></tr></table></blockquote>Stores the txid when the rotation was visible. </div></div><div class=CToolTip id="tt33"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td class="prettyprint">pgq.maint_tables_to_vacuum() returns setof text</td></tr></table></blockquote>Returns list of tablenames that need frequent vacuuming.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt34"><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.next_batch(</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><td class="PAfterParameters prettyprint "nowrap>) returns int8</td></tr></table></td></tr></table></blockquote>Old function that returns just batch_id.</div></div><div class=CToolTip id="tt35"><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.next_batch_custom(</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>in </td><td class="PType prettyprint " nowrap>i_min_lag </td><td class="PParameter prettyprint " nowrap>interval,</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>int4,</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>batch_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>cur_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>prev_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>cur_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>prev_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>cur_tick_event_seq </td><td class="PParameter prettyprint " nowrap>int8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>prev_tick_event_seq </td><td class="PParameter prettyprint " nowrap>int8</td><td class="PAfterParameters prettyprint "nowrap>) as</td></tr></table></td></tr></table></blockquote>Makes next block of events active. </div></div><div class=CToolTip id="tt36"><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.next_batch_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>batch_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>cur_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>prev_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>cur_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>prev_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>cur_tick_event_seq </td><td class="PParameter prettyprint " nowrap>int8,</td></tr><tr><td></td><td class="PTypePrefix prettyprint " nowrap>out </td><td class="PType prettyprint " nowrap>prev_tick_event_seq </td><td class="PParameter prettyprint " nowrap>int8</td><td class="PAfterParameters prettyprint "nowrap>) as</td></tr></table></td></tr></table></blockquote>Makes next block of events active.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt37"><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.quote_fqname(</td><td class="PType prettyprint " nowrap>i_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns text</td></tr></table></td></tr></table></blockquote>Quete fully-qualified object name for SQL.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt38"><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.register_consumer(</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_consumer_id </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Subscribe consumer on a queue.</div></div><div class=CToolTip id="tt39"><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.register_consumer_at(</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_consumer_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_tick_pos </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Extended registration, allows to specify tick_id.</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt40"><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.seq_getval(</td><td class="PType prettyprint " nowrap>i_seq_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>Read current last_val from seq, without affecting it.</div></div><div class=CToolTip id="tt41"><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.seq_setval(</td><td class="PType prettyprint " nowrap>i_seq_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>i_new_value </td><td class="PParameter prettyprint " nowrap>int8</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>Like setval() but does not allow going back.</div></div><div class=CToolTip id="tt42"><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.set_queue_config(</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_param_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>x_param_value </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Set configuration for specified queue.</div></div><div class=CToolTip id="tt43"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td class="prettyprint">pgq.sqltriga() RETURNS trigger AS</td></tr></table></blockquote>Trigger that generates queue events containing partial SQL. </div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt44"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td class="prettyprint">pgq.ticker() returns bigint</td></tr></table></blockquote>Creates ticks for all unpaused queues which dont have external ticker.</div></div><div class=CToolTip id="tt45"><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.ticker(</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>Check if tick is needed for the queue and insert it.</div></div><div class=CToolTip id="tt46"><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.ticker(</td><td class="PType prettyprint " nowrap>i_queue_name </td><td class="PParameter prettyprint " nowrap>text,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>i_tick_id </td><td class="PParameter prettyprint " nowrap>bigint,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>i_orig_timestamp </td><td class="PParameter prettyprint " nowrap>timestamptz,</td></tr><tr><td></td><td class="PType prettyprint " nowrap>i_event_seq </td><td class="PParameter prettyprint " nowrap>bigint</td><td class="PAfterParameters prettyprint "nowrap>) returns bigint</td></tr></table></td></tr></table></blockquote>External ticker: Insert a tick with a particular tick_id and timestamp.</div></div><div class=CToolTip id="tt47"><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.tune_storage(</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>Tunes storage settings for queue data tables</div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt48"><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.unregister_consumer(</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_consumer_name </td><td class="PParameter prettyprint " nowrap>text</td><td class="PAfterParameters prettyprint "nowrap>) returns integer</td></tr></table></td></tr></table></blockquote>Unsubscribe consumer from the queue. </div></div><!--END_ND_TOOLTIPS-->
<!--START_ND_TOOLTIPS-->
<div class=CToolTip id="tt49"><div class=CFunction><blockquote><table border=0 cellspacing=0 cellpadding=0 class="Prototype"><tr><td class="prettyprint">pgq.version() returns text</td></tr></table></blockquote>Returns version string for pgq. </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>
|