From e13486eba05cc46951a34263d19b65d1eca0176b Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Fri, 23 Dec 2016 07:35:01 -0500 Subject: Remove sql_inheritance GUC. This backward-compatibility GUC is long overdue for removal. Discussion: http://postgr.es/m/CA+TgmoYe+EG7LdYX6pkcNxr4ygkP4+A=jm9o-CPXyOvRiCNwaQ@mail.gmail.com --- doc/src/sgml/config.sgml | 30 ------------------------------ doc/src/sgml/ddl.sgml | 8 +++----- doc/src/sgml/queries.sgml | 8 +++----- 3 files changed, 6 insertions(+), 40 deletions(-) (limited to 'doc') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index b6b20a368ec..8d7b3bfd663 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7394,36 +7394,6 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' - - sql_inheritance (boolean) - - sql_inheritance configuration parameter - - inheritance - - - - This setting controls whether undecorated table references are - considered to include inheritance child tables. The default is - on, which means child tables are included (thus, - a * suffix is assumed by default). If turned - off, child tables are not included (thus, an - ONLY prefix is assumed). The SQL standard - requires child tables to be included, so the off setting - is not spec-compliant, but it is provided for compatibility with - PostgreSQL releases prior to 7.1. - See for more information. - - - - Turning 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 on. - - - - standard_conforming_strings (boolean) stringsstandard conforming diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 7e1bc0e5341..d7117cbc8f8 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -2529,11 +2529,9 @@ SELECT name, altitude WHERE altitude > 500; - Writing * is not necessary, since this behavior is - the default (unless you have changed the setting of the - configuration option). - However writing * might be useful to emphasize that - additional tables will be searched. + Writing * is not necessary, since this behavior is always + the default. However, this syntax is still supported for + compatibility with older releases where the default could be changed. diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 5cc6dbce11b..0f84c12bec6 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -145,11 +145,9 @@ FROM table_reference , table_r Instead of writing ONLY before the table name, you can write * after the table name to explicitly specify that descendant - tables are included. Writing * is not necessary since that - behavior is the default (unless you have changed the setting of the configuration option). However writing - * might be useful to emphasize that additional tables will be - searched. + tables are included. There is no real reason to use this syntax any more, + because searching descendent tables is now always the default behavior. + However, it is supported for compatibility with older releases. -- cgit v1.2.3