Skip to content

Commit 64c1399

Browse files
committed
* Make pg_get_triggerdef documentation consistent with other pg_get_
functions * Document pg_conversion_is_visible() which was created in one of my previous patches and didn't get documented for some reason Christopher Kings-Lynne
1 parent a6699f6 commit 64c1399

File tree

1 file changed

+19
-9
lines changed

1 file changed

+19
-9
lines changed

doc/src/sgml/func.sgml

Lines changed: 19 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.149 2003/03/27 16:35:30 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.150 2003/03/27 16:45:51 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -6757,6 +6757,12 @@ SELECT relname FROM pg_class WHERE pg_table_is_visible(oid);
67576757
<entry><type>boolean</type></entry>
67586758
<entry>is operator class visible in search path</entry>
67596759
</row>
6760+
<row>
6761+
<entry><literal><function>pg_conversion_is_visible</function>(<parameter>conversion_oid</parameter>)</literal>
6762+
</entry>
6763+
<entry><type>boolean</type></entry>
6764+
<entry>is conversion visible in search path</entry>
6765+
</row>
67606766
</tbody>
67616767
</tgroup>
67626768
</table>
@@ -6776,16 +6782,20 @@ SELECT relname FROM pg_class WHERE pg_table_is_visible(oid);
67766782
<indexterm zone="functions-misc">
67776783
<primary>pg_opclass_is_visible</primary>
67786784
</indexterm>
6785+
<indexterm zone="functions-misc">
6786+
<primary>pg_conversion_is_visible</primary>
6787+
</indexterm>
67796788

67806789
<para>
67816790
<function>pg_table_is_visible</function> performs the check for
67826791
tables (or views, or any other kind of <literal>pg_class</> entry).
67836792
<function>pg_type_is_visible</function>,
67846793
<function>pg_function_is_visible</function>,
6785-
<function>pg_operator_is_visible</function>, and
6786-
<function>pg_opclass_is_visible</function> perform the same sort of
6787-
visibility check for types, functions, operators, and operator
6788-
classes, respectively. For functions and operators, an object in
6794+
<function>pg_operator_is_visible</function>,
6795+
<function>pg_opclass_is_visible</function>, and
6796+
<function>pg_conversion_is_visible</function> perform the same sort of
6797+
visibility check for types, functions, operators, operator classes
6798+
and conversions, respectively. For functions and operators, an object in
67896799
the search path is visible if there is no object of the same name
67906800
<emphasis>and argument data type(s)</> earlier in the path. For
67916801
operator classes, both name and associated index access method are
@@ -6833,8 +6843,8 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
68336843
extract information from the system catalogs.
68346844
<function>pg_get_viewdef</function>,
68356845
<function>pg_get_ruledef</function>,
6836-
<function>pg_get_indexdef()</function>,
6837-
<function>pg_get_triggerdef()</function>, and
6846+
<function>pg_get_indexdef</function>,
6847+
<function>pg_get_triggerdef</function>, and
68386848
<function>pg_get_constraintdef</function> respectively
68396849
reconstruct the creating command for a view, rule, index, or
68406850
constraint. (Note that this is a decompiled reconstruction, not
@@ -6872,9 +6882,9 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
68726882
<entry>get <command>CREATE INDEX</> command for index</entry>
68736883
</row>
68746884
<row>
6875-
<entry><function>pg_get_triggerdef</function>(<parameter>triggerOID</parameter>)</entry>
6885+
<entry><function>pg_get_triggerdef</function>(<parameter>trigger_oid</parameter>)</entry>
68766886
<entry><type>text</type></entry>
6877-
<entry>Get <command>CREATE [ CONSTRAINT ] TRIGGER</> command for trigger</entry>
6887+
<entry>get <command>CREATE [ CONSTRAINT ] TRIGGER</> command for trigger</entry>
68786888
</row>
68796889
<row>
68806890
<entry><literal><function>pg_get_constraintdef</function>(<parameter>constraint_oid</parameter>)</literal></entry>

0 commit comments

Comments
 (0)