Commitfbbcbde

committed

Note that index_name in ALTER INDEX ATTACH PARTITION can be schema-qualified

Missed in8b08f7d; backpatch to all supported branches.Reported-by: alvaro@datadoghq.comReviewed-by: Tom Lane <tgl@sss.pgh.pa.us>Discussion:https://postgr.es/m/172924785099.698.15236991344616673753@wrigleys.postgresql.org

1 parent20d9489 commitfbbcbdeCopy full SHA for fbbcbde

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -87,10 +87,11 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable>`
`87`	`87`	`</varlistentry>`
`88`	`88`
`89`	`89`	`<varlistentry>`
`90`		`- <term><literal>ATTACH PARTITION</literal></term>`
	`90`	`+ <term><literal>ATTACH PARTITION <replaceable class="parameter">index_name</replaceable></literal></term>`
`91`	`91`	`<listitem>`
`92`	`92`	`<para>`
`93`		`- Causes the named index to become attached to the altered index.`
	`93`	`+ Causes the named index (possibly schema-qualified) to become attached`
	`94`	`+ to the altered index.`
`94`	`95`	`The named index must be on a partition of the table containing the`
`95`	`96`	`index being altered, and have an equivalent definition. An attached`
`96`	`97`	`index cannot be dropped by itself, and will automatically be dropped`

Comments

(0)