From 259c96fa8f78c0446eba1880850ea6fbe5092120 Mon Sep 17 00:00:00 2001 From: Alexander Korotkov Date: Tue, 30 Apr 2024 11:55:13 +0300 Subject: Inherit parent's AM for partition MERGE/SPLIT operations This commit makes new partitions created by ALTER TABLE ... SPLIT PARTITION and ALTER TABLE ... MERGE PARTITIONS commands inherit the paret table access method. Reported-by: Alexander Lakhin Discussion: https://postgr.es/m/84ada05b-be5c-473e-6d1c-ebe5dd21b190%40gmail.com Reviewed-by: Pavel Borisov --- doc/src/sgml/ref/alter_table.sgml | 2 ++ 1 file changed, 2 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index a7fed8a6010..ebd8c62038c 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1158,6 +1158,7 @@ WITH ( MODULUS numeric_literal, REM SQL command CREATE TABLE partition_nameN (LIKE name INCLUDING ALL EXCLUDING INDEXES EXCLUDING IDENTITY). The indexes and identity are created later, after moving the data into the new partitions. + New partitions will have the same table access method as the parent. If the parent table is persistent then new partitions are created persistent. If the parent table is temporary then new partitions are also created temporary. @@ -1227,6 +1228,7 @@ WITH ( MODULUS numeric_literal, REM SQL command CREATE TABLE partition_name (LIKE name INCLUDING ALL EXCLUDING INDEXES EXCLUDING IDENTITY). The indexes and identity are created later, after moving the data into the new partition. + The new partition will have the same table access method as the parent. If the parent table is persistent then the new partition is created persistent. If the parent table is temporary then the new partition is also created temporary. -- cgit v1.2.3