diff options
| author | Álvaro Herrera <alvherre@alvh.no-ip.org> | 2024-10-20 15:36:20 +0200 |
|---|---|---|
| committer | Álvaro Herrera <alvherre@alvh.no-ip.org> | 2024-10-20 15:36:20 +0200 |
| commit | f1c141fe143cc362d6db918db5008c25e2df7a62 (patch) | |
| tree | 0ad15f5181a7be374b6e4a518fc285a8ebedcf11 /doc/src | |
| parent | 11c87216d134a606938531e52edab6189bce6c2d (diff) | |
| download | postgresql-f1c141fe143cc362d6db918db5008c25e2df7a62.tar.gz postgresql-f1c141fe143cc362d6db918db5008c25e2df7a62.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_index.sgml | 5 |
1 files 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 |