diff options
Diffstat (limited to 'doc/src/sgml/config.sgml')
| -rw-r--r-- | doc/src/sgml/config.sgml | 22 |
1 files changed, 17 insertions, 5 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ade9f7974d2..cfdc803056f 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -5761,11 +5761,23 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' <indexterm><primary>inheritance</></> <listitem> <para> - This controls the inheritance semantics. If turned <literal>off</>, - subtables are not accessed by various commands by default; basically - an implied <literal>ONLY</literal> key word. This was added for - compatibility with releases prior to 7.1. See - <xref linkend="ddl-inherit"> for more information. + This setting controls whether undecorated table references are + considered to include inheritance child tables. The default is + <literal>on</>, which means child tables are included (thus, + a <literal>*</> suffix is assumed by default). If turned + <literal>off</>, child tables are not included (thus, an + <literal>ONLY</literal> prefix is assumed). The SQL standard + requires child tables to be included, so the <literal>off</> setting + is not spec-compliant, but it is provided for compatibility with + <productname>PostgreSQL</> releases prior to 7.1. + See <xref linkend="ddl-inherit"> for more information. + </para> + + <para> + Turning <varname>sql_inheritance</> off is deprecated, because that + behavior has been found to be error-prone as well as contrary to SQL + standard. Discussions of inheritance behavior elsewhere in this + manual generally assume that it is <literal>on</>. </para> </listitem> </varlistentry> |