diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 513112a216..bb494b3f89 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -3926,7 +3926,10 @@ ALTER TABLE measurement DETACH PARTITION measurement_y2006m02; the data using COPY, pg_dump, or similar tools. It might also be a useful time to aggregate data into smaller formats, perform other data manipulations, or run - reports. + reports. Moroever, specifying CONCURRENTLY allows + the detach operation to finish while taking only + SHARE UPDATE EXCLUSIVE lock on the parent table; see + for more information. @@ -4163,17 +4166,6 @@ ALTER INDEX measurement_city_id_logdate_key might be poor.) - - - - Some operations require a stronger lock when using declarative - partitioning than when using table inheritance. For example, - removing a partition from a partitioned table requires taking - an ACCESS EXCLUSIVE lock on the parent table, - whereas a SHARE UPDATE EXCLUSIVE lock is enough - in the case of regular inheritance. - - diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 6166b26334..3cce2fdbde 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -953,7 +953,7 @@ WITH ( MODULUS numeric_literal, REM - + DETACH PARTITION partition_name [ CONCURRENTLY | FINALIZE ]