Fail REPACK in presence of !indisready indexes

Like VACUUM FULL, non-concurrent REPACK would try to rebuild such
indexes, which can sometimes succeed.  Concurrent REPACK would however
fail.  The inconsistency is not good, so make them both throw an error
quickly to force the user to make a decision on those indexes (most
likely, drop them).

Author: Álvaro Herrera <[email protected]>
Reported-by: Zsolt Parragi <[email protected]>
Suggested-by: Kyotaro Horiguchi <[email protected]>
Discussion: 
https://postgr.es/m/CAN4CZFO5A3YE0Dd-bn7eKrB20pECO3=U0wKg1z2rO=dxgwj...@mail.gmail.com

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e14a2354d9f7e44b0ffcaeaf187aa475e3e7d11b

Modified Files
--------------
contrib/test_decoding/expected/repack.out | 16 +++++++
contrib/test_decoding/sql/repack.sql      |  8 ++++
src/backend/commands/repack.c             | 71 +++++++++++++++++++++++++++++++
3 files changed, 95 insertions(+)

Reply via email to