Datasetpublic
codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
rootpgsqlpgAdmin 4docsen_UShtmlevent_trigger_dialog.html
event_trigger_dialog.html228 linesDownload Raw Back to html
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6  <head>
7    <meta charset="utf-8" />
8    <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10    <title>Event Trigger Dialog &#8212; pgAdmin 4 8.6 documentation</title>
11    <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12    <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13    
14    <script src="_static/documentation_options.js?v=d4c83366"></script>
15    <script src="_static/doctools.js?v=9a2dae69"></script>
16    <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17    
18    <script src="_static/sidebar.js"></script>
19    
20    <link rel="index" title="Index" href="genindex.html" />
21    <link rel="search" title="Search" href="search.html" />
22    <link rel="next" title="Extension Dialog" href="extension_dialog.html" />
23    <link rel="prev" title="Domain Constraints Dialog" href="domain_constraint_dialog.html" /> 
24  </head><body>
25    <div class="related" role="navigation" aria-label="related navigation">
26      <h3>Navigation</h3>
27      <ul>
28        <li class="right" style="margin-right: 10px">
29          <a href="genindex.html" title="General Index"
30             accesskey="I">index</a></li>
31        <li class="right" >
32          <a href="extension_dialog.html" title="Extension Dialog"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="domain_constraint_dialog.html" title="Domain Constraints Dialog"
36             accesskey="P">previous</a> |</li>
37        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
38          <li class="nav-item nav-item-1"><a href="managing_database_objects.html" accesskey="U">Managing Database Objects</a> &#187;</li>
39        <li class="nav-item nav-item-this"><a href="">Event Trigger Dialog</a></li> 
40      </ul>
41    </div>  
42
43    <div class="document">
44      <div class="documentwrapper">
45        <div class="bodywrapper">
46          <div class="body" role="main">
47            
48  <section id="event-trigger-dialog">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Event Trigger Dialog<a class="headerlink" href="#event-trigger-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the <em>Event Trigger</em> dialog to define an event trigger. Unlike regular
51triggers, which are attached to a single table and capture only DML events,
52event triggers are global to a particular database and are capable of capturing
53DDL events.  Like regular triggers, event triggers can be written in any
54procedural language that includes event trigger support, or in C, but not in
55SQL.</p>
56<p>The <em>Event Trigger</em> dialog organizes the development of a event trigger through
57the following dialog tabs: <em>General</em>, <em>Definition</em>, and <em>Security Labels</em>. The
58<em>SQL</em> tab displays the SQL code generated by dialog selections.</p>
59<img alt="Event trigger dialog general tab" class="align-center" src="_images/event_trigger_general.png" />
60<p>Use the fields in the <em>General</em> tab to identify the event trigger:</p>
61<ul class="simple">
62<li><p>Use the <em>Name</em> field to add a descriptive name for the event trigger. The name
63will be displayed in the <em>pgAdmin</em> tree control.</p></li>
64<li><p>Use the drop-down listbox next to <em>Owner</em> to specify the owner of the event
65trigger.</p></li>
66<li><p>Store notes about the event trigger in the <em>Comment</em> field.</p></li>
67</ul>
68<p>Click the <em>Definition</em> tab to continue.</p>
69<img alt="Event trigger dialog definition tab" class="align-center" src="_images/event_trigger_definition.png" />
70<p>Use the fields in the <em>Definition</em> tab to define the event trigger:</p>
71<ul class="simple">
72<li><p>Select a value from the drop down of <em>Trigger Enabled</em> field to specify a status
73for the trigger: <em>Enable</em> <em>Disable</em>, <em>Replica</em> <em>Always</em>.</p></li>
74<li><p>Use the drop-down listbox next to <em>Trigger function</em> to specify an existing
75function.  A trigger function takes an empty argument list, and returns a
76value of type event_trigger.</p></li>
77<li><p>Select a value from the drop down of <em>Events</em> field to specify when the event
78trigger will fire: <em>DDL COMMAND START</em>, <em>DDL COMMAND END</em>, or <em>SQL DROP</em>.</p></li>
79<li><p>Use the <em>When TAG in</em> field to enter filter values for TAG for which the trigger
80will be executed. The values must be in single quotes separated by comma.</p></li>
81</ul>
82<p>Click the <em>Security Labels</em> tab to continue.</p>
83<img alt="Event trigger dialog security tab" class="align-center" src="_images/event_trigger_security.png" />
84<p>Use the <em>Security</em> tab to define security labels applied to the trigger. Click
85the <em>Add</em> icon (+) to add each security label.</p>
86<ul class="simple">
87<li><p>Specify a security label provider in the <em>Provider</em> field. The named provider
88must be loaded and must consent to the proposed labeling operation.</p></li>
89<li><p>Specify a security label in the <em>Security Label</em> field. The meaning of a given
90label is at the discretion of the label provider. PostgreSQL places no
91restrictions on whether or how a label provider must interpret security
92labels; it merely provides a mechanism for storing them.</p></li>
93</ul>
94<p>Click the <em>Add</em> icon (+) to assign additional security labels; to discard a
95security label, click the trash icon to the left of the row and confirm deletion
96in the <em>Delete Row</em> popup.</p>
97<p>Click the <em>SQL</em> tab to continue.</p>
98<p>Your entries in the <em>Event Trigger</em> dialog generate a generate a SQL command.
99Use the <em>SQL</em> tab for review; revisit or switch tabs to make any changes to the
100SQL command.</p>
101<section id="example">
102<h2>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h2>
103<p>The following is an example of the sql command generated by user selections in
104the <em>Event Trigger</em> dialog:</p>
105<img alt="Event trigger dialog sql tab" class="align-center" src="_images/event_trigger_sql.png" />
106<p>The command creates an event trigger named <em>accounts</em> that invokes the procedure
107named <em>evt_tri_fun</em>.</p>
108<ul class="simple">
109<li><p>Click the <em>Info</em> button (i) to access online help.</p></li>
110<li><p>Click the <em>Save</em> button to save work.</p></li>
111<li><p>Click the <em>Close</em> button to exit without saving work.</p></li>
112<li><p>Click the <em>Reset</em> button to restore configuration parameters.</p></li>
113</ul>
114</section>
115</section>
116
117
118            <div class="clearer"></div>
119          </div>
120        </div>
121      </div>
122      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
123        <div class="sphinxsidebarwrapper">
124  <div>
125    <h3><a href="index.html">Table of Contents</a></h3>
126    <ul>
127<li><a class="reference internal" href="#">Event Trigger Dialog</a><ul>
128<li><a class="reference internal" href="#example">Example</a></li>
129</ul>
130</li>
131</ul>
132
133  </div>
134<h3><a href="index.html">Table of Contents</a></h3>
135<ul class="current">
136<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
137<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
138<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
139<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
140<li class="toctree-l1 current"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a><ul class="current">
141<li class="toctree-l2"><a class="reference internal" href="cast_dialog.html">Cast Dialog</a></li>
142<li class="toctree-l2"><a class="reference internal" href="dbms_job_scheduler.html">Using EDB Job Scheduler</a></li>
143<li class="toctree-l2"><a class="reference internal" href="collation_dialog.html">Collation Dialog</a></li>
144<li class="toctree-l2"><a class="reference internal" href="domain_dialog.html">Domain Dialog</a></li>
145<li class="toctree-l2"><a class="reference internal" href="domain_constraint_dialog.html">Domain Constraints Dialog</a></li>
146<li class="toctree-l2 current"><a class="current reference internal" href="#">Event Trigger Dialog</a></li>
147<li class="toctree-l2"><a class="reference internal" href="extension_dialog.html">Extension Dialog</a></li>
148<li class="toctree-l2"><a class="reference internal" href="foreign_data_wrapper_dialog.html">Foreign Data Wrapper Dialog</a></li>
149<li class="toctree-l2"><a class="reference internal" href="foreign_server_dialog.html">Foreign Server Dialog</a></li>
150<li class="toctree-l2"><a class="reference internal" href="foreign_table_dialog.html">Foreign Table Dialog</a></li>
151<li class="toctree-l2"><a class="reference internal" href="fts_configuration_dialog.html">FTS Configuration Dialog</a></li>
152<li class="toctree-l2"><a class="reference internal" href="fts_dictionary_dialog.html">FTS Dictionary Dialog</a></li>
153<li class="toctree-l2"><a class="reference internal" href="fts_parser_dialog.html">FTS Parser Dialog</a></li>
154<li class="toctree-l2"><a class="reference internal" href="fts_template_dialog.html">FTS Template Dialog</a></li>
155<li class="toctree-l2"><a class="reference internal" href="function_dialog.html">Function Dialog</a></li>
156<li class="toctree-l2"><a class="reference internal" href="language_dialog.html">Language Dialog</a></li>
157<li class="toctree-l2"><a class="reference internal" href="materialized_view_dialog.html">Materialized View Dialog</a></li>
158<li class="toctree-l2"><a class="reference internal" href="package_dialog.html">Package Dialog</a></li>
159<li class="toctree-l2"><a class="reference internal" href="procedure_dialog.html">Procedure Dialog</a></li>
160<li class="toctree-l2"><a class="reference internal" href="publication_dialog.html">Publication Dialog</a></li>
161<li class="toctree-l2"><a class="reference internal" href="schema_dialog.html">Schema Dialog</a></li>
162<li class="toctree-l2"><a class="reference internal" href="sequence_dialog.html">Sequence Dialog</a></li>
163<li class="toctree-l2"><a class="reference internal" href="subscription_dialog.html">Subscription Dialog</a></li>
164<li class="toctree-l2"><a class="reference internal" href="synonym_dialog.html">Synonym Dialog</a></li>
165<li class="toctree-l2"><a class="reference internal" href="trigger_function_dialog.html">Trigger Function Dialog</a></li>
166<li class="toctree-l2"><a class="reference internal" href="type_dialog.html">Type Dialog</a></li>
167<li class="toctree-l2"><a class="reference internal" href="user_mapping_dialog.html">User Mapping Dialog</a></li>
168<li class="toctree-l2"><a class="reference internal" href="view_dialog.html">View Dialog</a></li>
169</ul>
170</li>
171<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
172<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
173<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
174<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
175<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
176<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
177<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
178<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
179<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
180</ul>
181
182<search id="searchbox" style="display: none" role="search">
183  <h3 id="searchlabel">Quick search</h3>
184    <div class="searchformwrapper">
185    <form class="search" action="search.html" method="get">
186      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
187      <input type="submit" value="Go" />
188    </form>
189    </div>
190</search>
191<script>document.getElementById('searchbox').style.display = "block"</script>
192        </div>
193<div id="sidebarbutton" title="Collapse sidebar">
194<span>«</span>
195</div>
196
197      </div>
198      <div class="clearer"></div>
199    </div>
200    <div class="related" role="navigation" aria-label="related navigation">
201      <h3>Navigation</h3>
202      <ul>
203        <li class="right" style="margin-right: 10px">
204          <a href="genindex.html" title="General Index"
205             >index</a></li>
206        <li class="right" >
207          <a href="extension_dialog.html" title="Extension Dialog"
208             >next</a> |</li>
209        <li class="right" >
210          <a href="domain_constraint_dialog.html" title="Domain Constraints Dialog"
211             >previous</a> |</li>
212        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
213          <li class="nav-item nav-item-1"><a href="managing_database_objects.html" >Managing Database Objects</a> &#187;</li>
214        <li class="nav-item nav-item-this"><a href="">Event Trigger Dialog</a></li> 
215      </ul>
216    </div>
217    <div class="footer" role="contentinfo">
218        <div class="related" role="navigation" aria-label="related navigation">
219          <ul>
220              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
221            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
222            <li class="right" ><a href="extension_dialog.html" title="Extension Dialog" accesskey="N">next</a> |</li>
223            <li class="right" ><a href="domain_constraint_dialog.html" title="Domain Constraints Dialog" accesskey="P">previous</a> |</li>
224          </ul>
225        </div>
226    </div>
227  </body>
228</html>