|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.186 2008/12/19 18:25:19 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.187 2009/01/09 01:53:10 adunstan Exp $ --> |
2 | 2 | <!-- |
3 | 3 | Documentation of the system catalogs, directed toward PostgreSQL developers |
4 | 4 | --> |
|
1909 | 1909 | <entry><structfield>confupdtype</structfield></entry> |
1910 | 1910 | <entry><type>char</type></entry> |
1911 | 1911 | <entry></entry> |
1912 | | - <entry>Foreign key update action code</entry> |
| 1912 | + <entry>Foreign key update action code: |
| 1913 | + <literal>a</> = no action, |
| 1914 | + <literal>r</> = restrict, |
| 1915 | + <literal>c</> = cascade, |
| 1916 | + <literal>n</> = set null, |
| 1917 | + <literal>d</> = set default |
| 1918 | + </entry> |
1913 | 1919 | </row> |
1914 | 1920 |
|
1915 | 1921 | <row> |
1916 | 1922 | <entry><structfield>confdeltype</structfield></entry> |
1917 | 1923 | <entry><type>char</type></entry> |
1918 | 1924 | <entry></entry> |
1919 | | - <entry>Foreign key deletion action code</entry> |
| 1925 | + <entry>Foreign key deletion action code: |
| 1926 | + <literal>a</> = no action, |
| 1927 | + <literal>r</> = restrict, |
| 1928 | + <literal>c</> = cascade, |
| 1929 | + <literal>n</> = set null, |
| 1930 | + <literal>d</> = set default |
| 1931 | + </entry> |
1920 | 1932 | </row> |
1921 | 1933 |
|
1922 | 1934 | <row> |
1923 | 1935 | <entry><structfield>confmatchtype</structfield></entry> |
1924 | 1936 | <entry><type>char</type></entry> |
1925 | 1937 | <entry></entry> |
1926 | | - <entry>Foreign key match type</entry> |
| 1938 | + <entry>Foreign key match type: |
| 1939 | + <literal>f</> = full, |
| 1940 | + <literal>p</> = partial, |
| 1941 | + <literal>u</> = simple (unspecified) |
| 1942 | + </entry> |
1927 | 1943 | </row> |
1928 | 1944 |
|
1929 | 1945 | <row> |
|