emit_retry_notification___f0cf628f.html (11274B)
1 <!DOCTYPE html> 2 <html> 3 <head> 4 <meta charset="utf-8"> 5 <meta http-equiv="X-UA-Compatible" content="IE=edge"> 6 <title>postgres.c2ec</title> 7 <!-- Tell the browser to be responsive to screen width --> 8 <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> 9 <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png"> 10 <!-- Bootstrap 3.3.5 --> 11 <link rel="stylesheet" href="../bower/admin-lte/bootstrap/css/bootstrap.min.css"> 12 <!-- Font Awesome --> 13 <link rel="stylesheet" href="../bower/font-awesome/css/font-awesome.min.css"> 14 <!-- Ionicons --> 15 <link rel="stylesheet" href="../bower/ionicons/css/ionicons.min.css"> 16 <!-- DataTables --> 17 <link rel="stylesheet" href="../bower/datatables.net-bs/css/dataTables.bootstrap.min.css"> 18 <link rel="stylesheet" href="../bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css"> 19 <!-- Code Mirror --> 20 <link rel="stylesheet" href="../bower/codemirror/codemirror.css"> 21 <!-- Fonts --> 22 <link href='../fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'> 23 <link href='../fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'> 24 25 <!-- Theme style --> 26 <link rel="stylesheet" href="../bower/admin-lte/dist/css/AdminLTE.min.css"> 27 <!-- Salvattore --> 28 <link rel="stylesheet" href="../bower/salvattore/salvattore.css"> 29 <!-- AdminLTE Skins. Choose a skin from the css/skins 30 folder instead of downloading all of them to reduce the load. --> 31 <link rel="stylesheet" href="../bower/admin-lte/dist/css/skins/_all-skins.min.css"> 32 <!-- SchemaSpy --> 33 <link rel="stylesheet" href="../schemaSpy.css"> 34 35 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> 36 <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> 37 <!--[if lt IE 9]> 38 <script src="../bower/html5shiv/html5shiv.min.js"></script> 39 <script src="../bower/respond/respond.min.js"></script> 40 <![endif]--> 41 </head> 42 <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. --> 43 <body class="hold-transition skin-blue layout-top-nav"> 44 <div class="wrapper"> 45 <header class="main-header"> 46 <nav class="navbar navbar-static-top"> 47 <div class="container"> 48 <div class="navbar-header"> 49 <a href="../index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span> 50 <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button> 51 </div> 52 53 <!-- Collect the nav links, forms, and other content for toggling --> 54 <div class="collapse navbar-collapse pull-left" id="navbar-collapse"> 55 <ul class="nav navbar-nav"> 56 <li><a href="../index.html">Tables <span class="sr-only">(current)</span></a></li> 57 <li><a href="../columns.html" title="All of the columns in the schema">Columns</a></li> 58 <li><a href="../constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li> 59 <li><a href="../relationships.html" title="Diagram of table relationships">Relationships</a></li> 60 <li><a href="../orphans.html" title="View of tables with neither parents nor children">Orphan Tables</a></li> 61 <li><a href="../anomalies.html" title="Things that might not be quite right">Anomalies</a></li> 62 <li><a href="../routines.html" title="Procedures and functions">Routines</a></li> 63 </ul> 64 </div> 65 <!-- /.navbar-collapse --> 66 <!-- Navbar Right Menu --> 67 </div> 68 <!-- /.container-fluid --> 69 </nav> 70 </header> 71 <!-- Main content --> 72 <!-- Full Width Column --> 73 <div class="content-wrapper"> 74 <!-- Content Header (Page header) --> 75 <section class="content-header"> 76 <h1>emit_retry_notification()</h1><br /> 77 <div class="box box-primary"> 78 <div class="box-header with-border"> 79 <i class="fa fa-file-text-o"></i> 80 <h3 id="Description" class="box-title">Description</h3> 81 <div class="box-tools pull-right"> 82 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 83 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 84 </div> 85 </div> 86 <!-- /.box-header --> 87 <div class="box-body clearfix"> 88 <p><p>The function emits the id of the withdrawal for which the last retry timestamp was updated. This shall trigger a retry operation. How many retries are attempted is specified and handled by the application</p></p> 89 </div> 90 <!-- /.box-body --> 91 </div> 92 </section> 93 <!-- Main content --> 94 <section class="content"> 95 <div class="box box-primary"> 96 <div class="box-header with-border"> 97 <span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span> 98 <h3 id="Columns" class="box-title">Parameters</h3> 99 <div class="box-tools pull-right"> 100 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 101 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 102 </div> 103 </div> 104 <div class="box-body"> 105 <table id="standard_table" class="table table-bordered table-striped dataTable" role="grid"> 106 <thead align='left'> 107 <tr> 108 <th>Name</th> 109 <th>Type</th> 110 <th>Mode</th> 111 </tr> 112 </thead> 113 <tbody> 114 <tr> 115 <td></td> 116 <td></td> 117 <td>IN</td> 118 </tr> 119 </tbody> 120 </table> 121 </div> 122 </div> 123 <div class="box box-primary"> 124 <div class="box-header with-border"> 125 <i class="fa fa-file-code-o"></i> 126 <h3 id="RoutineDefinition" class="box-title">Definition</h3> 127 <div class="box-tools pull-right"> 128 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> 129 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> 130 </div> 131 </div> 132 <div class="box-body"> 133 <textarea id="sql-script-codemirror" name="sql-script-codemirror" rows="" style="display: none;">BEGIN PERFORM pg_notify('retry', '' || NEW.withdrawal_row_id); RETURN NULL; END;</textarea> 134 </div> 135 </div> 136 </section> 137 </div> 138 <!-- /.content-wrapper --> 139 <footer class="main-footer"> 140 <div> 141 <div class="pull-right hidden-xs"> 142 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> 143 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> 144 </div> 145 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong> 146 </div> 147 <!-- /.container --> 148 </footer> 149 </div> 150 <!-- ./wrapper --> 151 152 <!-- jQuery 2.2.3 --> 153 <script src="../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> 154 <script src="../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> 155 <!-- Bootstrap 3.3.5 --> 156 <script src="../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> 157 <!-- DataTables --> 158 <script src="../bower/datatables.net/jquery.dataTables.min.js"></script> 159 <script src="../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> 160 <script src="../bower/datatables.net-buttons/dataTables.buttons.min.js"></script> 161 <script src="../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> 162 <script src="../bower/datatables.net-buttons/buttons.html5.min.js"></script> 163 <script src="../bower/datatables.net-buttons/buttons.print.min.js"></script> 164 <script src="../bower/datatables.net-buttons/buttons.colVis.min.js"></script> 165 <!-- SheetJS --> 166 <script src="../bower/js-xlsx/xlsx.full.min.js"></script> 167 <!-- pdfmake --> 168 <script src="../bower/pdfmake/pdfmake.min.js"></script> 169 <script src="../bower/pdfmake/vfs_fonts.js"></script> 170 <!-- SlimScroll --> 171 <script src="../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> 172 <!-- FastClick --> 173 <script src="../bower/admin-lte/plugins/fastclick/fastclick.js"></script> 174 <!-- Salvattore --> 175 <script src="../bower/salvattore/salvattore.min.js"></script> 176 <!-- AnchorJS --> 177 <script src="../bower/anchor-js/anchor.min.js"></script> 178 <!-- CodeMirror --> 179 <script src="../bower/codemirror/codemirror.js"></script> 180 <script src="../bower/codemirror/sql.js"></script> 181 <!-- AdminLTE App --> 182 <script src="../bower/admin-lte/dist/js/app.min.js"></script> 183 <script src="routine.js"></script> 184 <script src="../schemaSpy.js"></script> 185 </body> 186 </html>