postgres.git / summary / log / commit / refs

commit    fbbcbdef23349a81efad2bf742c94e2dc6c28130
Author:   Álvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Sun Oct 20 13:36:20 2024 +0000

    Note that index_name in ALTER INDEX ATTACH PARTITION can be schema-qualified
    
    Missed in 8b08f7d4820f; backpatch to all supported branches.
    
    Reported-by: alvaro@datadoghq.com
    Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
    Discussion: https://postgr.es/m/172924785099.698.15236991344616673753@wrigleys.postgresql.org


 doc/src/sgml/ref/alter_index.sgml | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml
index e26efec064b..1d42d05d858 100644
--- a/doc/src/sgml/ref/alter_index.sgml
+++ b/doc/src/sgml/ref/alter_index.sgml
@@ -87,10 +87,11 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable>
    </varlistentry>
 
    <varlistentry>
-    <term><literal>ATTACH PARTITION</literal></term>
+    <term><literal>ATTACH PARTITION <replaceable class="parameter">index_name</replaceable></literal></term>
     <listitem>
      <para>
-      Causes the named index to become attached to the altered index.
+      Causes the named index (possibly schema-qualified) to become attached
+      to the altered index.
       The named index must be on a partition of the table containing the
       index being altered, and have an equivalent definition.  An attached
       index cannot be dropped by itself, and will automatically be dropped


[parent: 20d94899414a]