From 3be6367b9f14e33b10d19e9556fb018731a720e6 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 20 Mar 2003 18:58:02 +0000
Subject: This patch creates a function named pg_get_triggerdef that takes the
 oid of a trigger as its parameter.  It is basically copied from the pg_dump
 code.

Christopher Kings-Lynne
---
 doc/src/sgml/func.sgml | 19 ++++++++++++++-----
 1 file changed, 14 insertions(+), 5 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 256b0fa3fae..27966276d0e 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.144 2003/03/20 03:34:55 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.145 2003/03/20 18:58:02 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -6795,6 +6795,10 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
     <primary>pg_get_indexdef</primary>
    </indexterm>
 
+   <indexterm zone="functions-misc">
+    <primary>pg_get_triggerdef</primary>
+   </indexterm>
+
    <indexterm zone="functions-misc">
     <primary>pg_get_constraintdef</primary>
    </indexterm>
@@ -6808,13 +6812,13 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
    extract information from the system catalogs.
    <function>pg_get_viewdef</function>,
    <function>pg_get_ruledef</function>,
-   <function>pg_get_indexdef</function>, and
+   <function>pg_get_indexdef()</function>,
+   <function>pg_get_triggerdef()</function>, and
    <function>pg_get_constraintdef</function> respectively
    reconstruct the creating command for a view, rule, index, or
    constraint.  (Note that this is a decompiled reconstruction, not
-   the verbatim text of the command.)  At present
-   <function>pg_get_constraintdef</function> only works for
-   foreign-key constraints.  <function>pg_get_userbyid</function>
+   the verbatim text of the command.)
+   <function>pg_get_userbyid</function>
    extracts a user's name given a user ID number.
   </para>
 
@@ -6846,6 +6850,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
        <entry><type>text</type></entry>
        <entry>get <command>CREATE INDEX</> command for index</entry>
       </row>
+      <row>
+       <entry><function>pg_get_triggerdef</function>(<parameter>triggerOID</parameter>)</entry>
+       <entry><type>text</type></entry>
+       <entry>Get <command>CREATE [ CONSTRAINT ] TRIGGER</> command for trigger</entry>
+      </row>
       <row>
        <entry><literal><function>pg_get_constraintdef</function>(<parameter>constraint_oid</parameter>)</literal></entry>
        <entry><type>text</type></entry>
-- 
cgit v1.2.3