pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI
Date: 2023-03-16 20:51:04
Message-ID: E1pcuYy-003s5z-38@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITION OF.

Clarify that ATTACH/DETACH PARTITION can be used to perform partition
maintenance with less locking than straight CREATE TABLE/DROP TABLE.
This was already stated in some places, but not emphasized.

Back-patch to v14 where DETACH PARTITION CONCURRENTLY was added.
(We had lower lock levels for ATTACH PARTITION before that, but
this wording wouldn't apply.)

Justin Pryzby, reviewed by Robert Treat and Jakub Wartak;
a little further wordsmithing by me

Discussion: https://postgr.es/m/20220718143304.GC18011@telsasoft.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f170b572d2b4cc232c5b6d391b4ecf3e368594b7

Modified Files
--------------
doc/src/sgml/ddl.sgml | 13 +++++++------
doc/src/sgml/ref/create_table.sgml | 20 ++++++++++++++++----
2 files changed, 23 insertions(+), 10 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2023-03-16 21:47:02 pgsql: Small tidyup for commit d41a178b.
Previous Message Tom Lane 2023-03-16 18:18:49 pgsql: Tighten error checks in datetime input, and remove bogus "ISO" f