diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2012-01-25 13:15:29 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2012-01-25 13:22:54 -0300 |
| commit | 74ab96a45ef6259aa6a86a781580edea8488511a (patch) | |
| tree | 92415eea1e32bb33c68b9fdbbdc5c57732d78c68 /doc/src | |
| parent | 6d5aae7afacc564ead2af88c76b13cfc55750556 (diff) | |
| download | postgresql-74ab96a45ef6259aa6a86a781580edea8488511a.tar.gz postgresql-74ab96a45ef6259aa6a86a781580edea8488511a.zip | |
Add pg_trigger_depth() function
This reports the depth level of triggers currently in execution, or zero
if not called from inside a trigger.
No catversion bump in this patch, but you have to initdb if you want
access to the new function.
Author: Kevin Grittner
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 48631cc341c..219ba9abf39 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -12795,6 +12795,13 @@ postgres=# SELECT * FROM unnest2(ARRAY[[1,2],[3,4]]); </row> <row> + <entry><literal><function>pg_trigger_depth()</function></literal></entry> + <entry><type>int</type></entry> + <entry>current nesting level of <productname>PostgreSQL</> triggers + (0 if not called, directly or indirectly, from inside a trigger)</entry> + </row> + + <row> <entry><literal><function>session_user</function></literal></entry> <entry><type>name</type></entry> <entry>session user name</entry> |