pgsql: Improve documentation about CREATE TABLE ... LIKE.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve documentation about CREATE TABLE ... LIKE.
Date: 2016-07-28 17:27:22
Message-ID: E1bSp5e-0007tt-NY@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve documentation about CREATE TABLE ... LIKE.

The docs failed to explain that LIKE INCLUDING INDEXES would not preserve
the names of indexes and associated constraints. Also, it wasn't mentioned
that EXCLUDE constraints would be copied by this option. The latter
oversight seems enough of a documentation bug to justify back-patching.

In passing, do some minor copy-editing in the same area, and add an entry
for LIKE under "Compatibility", since it's not exactly a faithful
implementation of the standard's feature.

Discussion: <20160728151154(dot)AABE64016B(at)smtp(dot)hushmail(dot)com>

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/c92aca1236b5ed789873220948030a639a55e67a

Modified Files
--------------
doc/src/sgml/ref/create_table.sgml | 52 ++++++++++++++++++++++++++------------
src/backend/parser/parse_utilcmd.c | 4 ++-
2 files changed, 39 insertions(+), 17 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-07-28 20:09:34 pgsql: Fix assorted fallout from IS [NOT] NULL patch.
Previous Message Tom Lane 2016-07-28 15:39:33 pgsql: Register atexit hook only once in pg_upgrade.