From 35b04e964289ac049907bdc19f36328d2d6c4770 Mon Sep 17 00:00:00 2001 From: "David G. Johnston" Date: Sat, 17 Jan 2026 09:12:25 -0700 Subject: [PATCH] v3 edits --- doc/src/sgml/ref/alter_table.sgml | 28 ++++++++++------------------ doc/src/sgml/ref/create_table.sgml | 4 ++-- 2 files changed, 12 insertions(+), 20 deletions(-) diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 8577e2cdcdd..6131632d20b 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -746,11 +746,8 @@ WITH ( MODULUS numeric_literal, REM When this command is applied to a partitioned table, the states of - corresponding clone triggers in existing partitions are updated too, - unless ONLY is specified. Triggers in partitions - created afterwards inherit the trigger state from the partitioned - table, while individual partitions may configure trigger states - independently. + corresponding clone triggers are updated too, unless ONLY + is specified. This command acquires a SHARE ROW EXCLUSIVE lock. @@ -882,14 +879,11 @@ WITH ( MODULUS numeric_literal, REM See for more information. - When applied to a partitioned table, there is no data to rewrite. - Partitions created afterwards will use the access method specified - on the partitioned table, if any, unless overridden by a - USING clause; otherwise they default to - default_table_access_method. Specifying - DEFAULT removes a previously set access method, - causing future partitions to use - default_table_access_method. + When applied to a partitioned table, there is no data to rewrite, + only the default for newly created partitions is changed. + Specifying DEFAULT removes a previously set access method, + causing future partitions to use default_table_access_method. + Individual partitions are affected just like any other regular table. @@ -902,10 +896,8 @@ WITH ( MODULUS numeric_literal, REM moves the data file(s) associated with the table to the new tablespace. Indexes on the table, if any, are not moved; but they can be moved separately with additional SET TABLESPACE commands. - When applied to a partitioned table, no data is moved. Existing - partitions are not affected, but partitions created afterwards with - CREATE TABLE PARTITION OF will use the specified - tablespace unless overridden by a TABLESPACE clause. + When applied to a partitioned table, no data is moved, only the default + for newly created partitions is changed. All tables in the current database in a tablespace can be moved by using @@ -984,7 +976,7 @@ WITH ( MODULUS numeric_literal, REM When applied to a partitioned table, this form is accepted but has no - effect. It can be used on individual partitions, where it + practical effect. It can be used on individual partitions, where it behaves as for a regular table. diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 780e4f0799f..835f609e2a6 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -635,9 +635,9 @@ WITH ( MODULUS numeric_literal, REM When a new partition is created, it generally inherits the current - definition-level settings of the parent partitioned table. However, + definition-level properties of the parent partitioned table. However, some table properties are not inherited automatically. In particular, - settings related to ownership, schema, replica identity, row-level + properties related to ownership, schema, replica identity, row-level security configuration, per-attribute statistics targets, and per-attribute options are not inherited unless explicitly specified for the partition. -- 2.43.0