ALTER TABLE DETACH CONCURRENTLY had to deal with this also, and it did it by having a COMPLETE option you can run later in case things got stuck the first time around. I suppose we could do something similar, where the server automatically does the needful, whatever that is.
- Does a cancelled REINDEX CONCURRENTLY need to be messy? Thom Brown
- Re: Does a cancelled REINDEX CONCURRENTLY need to be... Andreas Karlsson
- Re: Does a cancelled REINDEX CONCURRENTLY need t... Tom Lane
- Re: Does a cancelled REINDEX CONCURRENTLY ne... Álvaro Herrera
- Re: Does a cancelled REINDEX CONCURRENTL... Thom Brown
- Re: Does a cancelled REINDEX CONCUR... Álvaro Herrera
- Re: Does a cancelled REINDEX CO... Michael Paquier
- Re: Does a cancelled REINDE... Álvaro Herrera
- Re: Does a cancelled REINDEX CO... Peter Eisentraut