Datasetpublic
codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face
1likes14kdownloads
rootpgsqlpgAdmin 4docsen_UShtmlcompound_trigger_dialog.html
compound_trigger_dialog.html203 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>Compound 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="Exclusion Constraint Dialog" href="exclusion_constraint_dialog.html" />
23    <link rel="prev" title="Column Dialog" href="column_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="exclusion_constraint_dialog.html" title="Exclusion Constraint Dialog"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="column_dialog.html" title="Column 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="modifying_tables.html" accesskey="U">Creating or Modifying a Table</a> &#187;</li>
39        <li class="nav-item nav-item-this"><a href="">Compound 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="compound-trigger-dialog">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Compound Trigger Dialog<a class="headerlink" href="#compound-trigger-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the <em>Compound Trigger</em> dialog to create a compound trigger or modify an
51existing compound trigger. <em>Compound Trigger</em> is supported only for EPAS server
5212 and above. A compound trigger executes a specified code when certain events
53occur.</p>
54<p>The <em>Compound Trigger</em> dialog organizes the development of a compound trigger
55through the following dialog tabs: <em>General</em>, <em>Events</em>, and <em>Code</em>. The <em>SQL</em>
56tab displays the SQL code generated by dialog selections.</p>
57<img alt="Compound Trigger dialog general tab" class="align-center" src="_images/compound_trigger_general.png" />
58<p>Use the fields in the <em>General</em> tab to identify the compound trigger:</p>
59<ul class="simple">
60<li><p>Use the <em>Name</em> field to add a descriptive name for the compound trigger. This
61must be distinct from the name of any other compound trigger for the same table.
62The name will be displayed in the <em>pgAdmin</em> tree control.</p></li>
63<li><p>Store notes about the compound trigger in the <em>Comment</em> field.</p></li>
64</ul>
65<img alt="Trigger enabled in dialog tab" class="align-center" src="_images/compound_trigger_general_enabled.png" />
66<ul class="simple">
67<li><p><em>Trigger enabled</em> field is available in compound trigger dialog once the trigger is created.
68You can select one of the four options available.</p></li>
69</ul>
70<p>Click the <em>Events</em> tab to continue.</p>
71<img alt="Compound Trigger dialog events tab" class="align-center" src="_images/compound_trigger_events.png" />
72<p>Use the fields in the <em>Events</em> tab to specify how and when the compound trigger fires:</p>
73<ul class="simple">
74<li><p>Select the type of event(s) that will invoke the compound trigger; to select
75an event type, move the switch next to the event to the <em>YES</em> position.
76The supported event types are <em>INSERT</em>, <em>UPDATE</em>, <em>DELETE</em> and <em>TRUNCATE</em>.
77Views cannot have TRUNCATE triggers.</p></li>
78<li><p>Use the <em>When</em> field to provide a boolean condition that will invoke the
79compound trigger.</p></li>
80<li><p>If defining a column-specific compound trigger, use the <em>Columns</em> field to
81specify the columns or columns that are the target of the compound trigger.</p></li>
82</ul>
83<p>Click the <em>Code</em> tab to continue.</p>
84<img alt="Compound Trigger dialog code tab" class="align-center" src="_images/compound_trigger_code.png" />
85<p>Use the <em>Code</em> field to specify the code for the five timing events
86<em>BEFORE STATEMENT</em>, <em>AFTER STATEMENT</em>, <em>BEFORE EACH ROW</em>, <em>AFTER EACH ROW</em>,
87<em>INSTEAD OF EACH ROW</em> that will be invoked when the compound trigger fires.
88Basic template is provided with place holders.</p>
89<p>Click the <em>SQL</em> tab to continue.</p>
90<p>Your entries in the <em>Compound Trigger</em> dialog generate a SQL command (see an example
91below). Use the <em>SQL</em> tab for review; revisit or switch tabs to make any changes
92to the SQL command.</p>
93<section id="example">
94<h2>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h2>
95<p>The following is an example of the sql command generated by user selections in
96the <em>Compound Trigger</em> dialog:</p>
97<img alt="Compound Trigger dialog sql tab" class="align-center" src="_images/compound_trigger_sql.png" />
98<p>The example demonstrates creating a compound trigger named <em>test_ct</em>.</p>
99<ul class="simple">
100<li><p>Click the <em>Info</em> button (i) to access online help.</p></li>
101<li><p>Click the <em>Save</em> button to save work.</p></li>
102<li><p>Click the <em>Close</em> button to exit without saving work.</p></li>
103<li><p>Click the <em>Reset</em> button to restore configuration parameters.</p></li>
104</ul>
105</section>
106</section>
107
108
109            <div class="clearer"></div>
110          </div>
111        </div>
112      </div>
113      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
114        <div class="sphinxsidebarwrapper">
115  <div>
116    <h3><a href="index.html">Table of Contents</a></h3>
117    <ul>
118<li><a class="reference internal" href="#">Compound Trigger Dialog</a><ul>
119<li><a class="reference internal" href="#example">Example</a></li>
120</ul>
121</li>
122</ul>
123
124  </div>
125<h3><a href="index.html">Table of Contents</a></h3>
126<ul class="current">
127<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
128<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
129<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
130<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
131<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
132<li class="toctree-l1 current"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a><ul class="current">
133<li class="toctree-l2"><a class="reference internal" href="check_dialog.html">Check Dialog</a></li>
134<li class="toctree-l2"><a class="reference internal" href="column_dialog.html">Column Dialog</a></li>
135<li class="toctree-l2 current"><a class="current reference internal" href="#">Compound Trigger Dialog</a></li>
136<li class="toctree-l2"><a class="reference internal" href="exclusion_constraint_dialog.html">Exclusion Constraint Dialog</a></li>
137<li class="toctree-l2"><a class="reference internal" href="foreign_key_dialog.html">Foreign key Dialog</a></li>
138<li class="toctree-l2"><a class="reference internal" href="index_dialog.html">Index Dialog</a></li>
139<li class="toctree-l2"><a class="reference internal" href="primary_key_dialog.html">Primary key Dialog</a></li>
140<li class="toctree-l2"><a class="reference internal" href="rls_policy_dialog.html">RLS Policy Dialog</a></li>
141<li class="toctree-l2"><a class="reference internal" href="rule_dialog.html">Rule Dialog</a></li>
142<li class="toctree-l2"><a class="reference internal" href="table_dialog.html">Table Dialog</a></li>
143<li class="toctree-l2"><a class="reference internal" href="trigger_dialog.html">Trigger Dialog</a></li>
144<li class="toctree-l2"><a class="reference internal" href="unique_constraint_dialog.html">Unique Constraint Dialog</a></li>
145</ul>
146</li>
147<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
148<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
149<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
150<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
151<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
152<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
153<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
154<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
155</ul>
156
157<search id="searchbox" style="display: none" role="search">
158  <h3 id="searchlabel">Quick search</h3>
159    <div class="searchformwrapper">
160    <form class="search" action="search.html" method="get">
161      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
162      <input type="submit" value="Go" />
163    </form>
164    </div>
165</search>
166<script>document.getElementById('searchbox').style.display = "block"</script>
167        </div>
168<div id="sidebarbutton" title="Collapse sidebar">
169<span>«</span>
170</div>
171
172      </div>
173      <div class="clearer"></div>
174    </div>
175    <div class="related" role="navigation" aria-label="related navigation">
176      <h3>Navigation</h3>
177      <ul>
178        <li class="right" style="margin-right: 10px">
179          <a href="genindex.html" title="General Index"
180             >index</a></li>
181        <li class="right" >
182          <a href="exclusion_constraint_dialog.html" title="Exclusion Constraint Dialog"
183             >next</a> |</li>
184        <li class="right" >
185          <a href="column_dialog.html" title="Column Dialog"
186             >previous</a> |</li>
187        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
188          <li class="nav-item nav-item-1"><a href="modifying_tables.html" >Creating or Modifying a Table</a> &#187;</li>
189        <li class="nav-item nav-item-this"><a href="">Compound Trigger Dialog</a></li> 
190      </ul>
191    </div>
192    <div class="footer" role="contentinfo">
193        <div class="related" role="navigation" aria-label="related navigation">
194          <ul>
195              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
196            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
197            <li class="right" ><a href="exclusion_constraint_dialog.html" title="Exclusion Constraint Dialog" accesskey="N">next</a> |</li>
198            <li class="right" ><a href="column_dialog.html" title="Column Dialog" accesskey="P">previous</a> |</li>
199          </ul>
200        </div>
201    </div>
202  </body>
203</html>