]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Raise error on concurrent drop of partitioned index
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 1 Sep 2020 17:40:43 +0000 (13:40 -0400)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 1 Sep 2020 17:40:43 +0000 (13:40 -0400)
commit15dad5776578e884ee7857abb278a116c0c3e578
tree37b5509a8a6c571e955d0c141c6c356270f8b74f
parent4178b749963cbf28d438b81e38dedcf885ccdda3
Raise error on concurrent drop of partitioned index

We were already raising an error for DROP INDEX CONCURRENTLY on a
partitioned table, albeit a different and confusing one:
  ERROR:  DROP INDEX CONCURRENTLY must be first action in transaction

Change that to throw a more comprehensible error:
  ERROR:  cannot drop partitioned index \"%s\" concurrently

Michael Paquier authored the test case for indexes on temporary
partitioned tables.

Backpatch to 11, where indexes on partitioned tables were added.

Reported-by: Jan Mussler <jan.mussler@zalando.de>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/16594-d2956ca909585067@postgresql.org
doc/src/sgml/ref/drop_index.sgml
src/backend/commands/tablecmds.c
src/test/regress/expected/indexing.out
src/test/regress/sql/indexing.sql