pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI
Date
Msg-id E1pcuYy-003s60-3k@gemulon.postgresql.org
Whole thread Raw
List 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
------
REL_15_STABLE

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

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


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Tighten error checks in datetime input, and remove bogus "ISO" f
Next
From: Thomas Munro
Date:
Subject: pgsql: Small tidyup for commit d41a178b.