From a208ea72bced456c4234644e4c9eda8969e8bdc9 Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Fri, 16 Aug 2002 23:01:21 +0000
Subject: Modify pg_dump to dump foreign-key constraints as constraints, not as
 sets of triggers.  Also modify psql \d command to show foreign key
 constraints as such and hide the triggers.  pg_get_constraintdef() function
 added to backend to support these.  From Rod Taylor, code review and some
 editorialization by Tom Lane.

---
 doc/src/sgml/func.sgml | 22 ++++++++++++++++++----
 1 file changed, 18 insertions(+), 4 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index f136088fe84..bf2ce4667e2 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.111 2002/08/14 02:45:09 ishii Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.112 2002/08/16 23:01:18 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -5521,6 +5521,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
        <entry><type>text</type></entry>
        <entry>Get CREATE INDEX command for index</entry>
       </row>
+      <row>
+       <entry><function>pg_get_constraintdef</function>(<parameter>constraintOID</parameter>)</entry>
+       <entry><type>text</type></entry>
+       <entry>Get definition of a constraint</entry>
+      </row>
       <row>
        <entry><function>pg_get_userbyid</function>(<parameter>userid</parameter>)</entry>
        <entry><type>name</type></entry>
@@ -5542,16 +5547,25 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
     <primary>pg_get_indexdef</primary>
    </indexterm>
 
+   <indexterm zone="functions-misc">
+    <primary>pg_get_constraintdef</primary>
+   </indexterm>
+
    <indexterm zone="functions-misc">
     <primary>pg_get_userbyid</primary>
    </indexterm>
 
    <para>
     These functions extract information from the system catalogs.
-    <function>pg_get_viewdef()</function>, <function>pg_get_ruledef()</function>, and
-    <function>pg_get_indexdef()</function> respectively reconstruct the creating
-    command for a view, rule, or index.  (Note that this is a decompiled
+    <function>pg_get_viewdef()</function>,
+    <function>pg_get_ruledef()</function>,
+    <function>pg_get_indexdef()</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> extracts a user's name given a
     <structfield>usesysid</structfield> value.
    </para>
-- 
cgit v1.2.3