postgres.git / summary / log / commit / refs

commit    e2989fcab6150da5b4296eb1481284ad2825892e
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sat Jan 25 19:32:48 2014 +0000
First released in: 9.4.0

    docs: mention CREATE TABLE LIKE linkage using INCLUDING DEFAULTS
    
    Mention that CREATE TABLE LIKE INCLUDING DEFAULTS creates a link between
    the original and new tables if a default function modifies the database,
    like nextval().


doc/src/sgml/ref/create_table.sgml | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index a422edd2313..e0b8a4ecaf6 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -329,7 +329,10 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI </para> <para> Default expressions for the copied column definitions will only be - copied if <literal>INCLUDING DEFAULTS</literal> is specified. The + copied if <literal>INCLUDING DEFAULTS</literal> is specified. + Defaults that call database-modification functions, like + <function>nextval</>, create a linkage between the original and + new tables. The default behavior is to exclude default expressions, resulting in the copied columns in the new table having null defaults. </para> [parent: 71c6a8e375b1]