diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2009-01-09 01:53:10 +0000 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2009-01-09 01:53:10 +0000 |
| commit | 32e1265dd97e8321ad67418b781f3d0cf8a9282c (patch) | |
| tree | 2d0c156c7b86cbeb29fdd80c37a563458492ae22 | |
| parent | 32c34aab1d2dd8db097c8b265d5e6d99babd611c (diff) | |
| download | postgresql-32e1265dd97e8321ad67418b781f3d0cf8a9282c.tar.gz postgresql-32e1265dd97e8321ad67418b781f3d0cf8a9282c.zip | |
Document values for pg_constraint confupdtype, confdeltype and confmatchtype columns.
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 24 |
1 files changed, 20 insertions, 4 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index a25d2356da3..a4006f3e20e 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.186 2008/12/19 18:25:19 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.187 2009/01/09 01:53:10 adunstan Exp $ --> <!-- Documentation of the system catalogs, directed toward PostgreSQL developers --> @@ -1909,21 +1909,37 @@ <entry><structfield>confupdtype</structfield></entry> <entry><type>char</type></entry> <entry></entry> - <entry>Foreign key update action code</entry> + <entry>Foreign key update action code: + <literal>a</> = no action, + <literal>r</> = restrict, + <literal>c</> = cascade, + <literal>n</> = set null, + <literal>d</> = set default + </entry> </row> <row> <entry><structfield>confdeltype</structfield></entry> <entry><type>char</type></entry> <entry></entry> - <entry>Foreign key deletion action code</entry> + <entry>Foreign key deletion action code: + <literal>a</> = no action, + <literal>r</> = restrict, + <literal>c</> = cascade, + <literal>n</> = set null, + <literal>d</> = set default + </entry> </row> <row> <entry><structfield>confmatchtype</structfield></entry> <entry><type>char</type></entry> <entry></entry> - <entry>Foreign key match type</entry> + <entry>Foreign key match type: + <literal>f</> = full, + <literal>p</> = partial, + <literal>u</> = simple (unspecified) + </entry> </row> <row> |