On Thu, 29 Jun 2023, 14:45 Álvaro Herrera, <alvhe...@alvh.no-ip.org> wrote:
> 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. > So there doesn't appear to be provision for deferred activities. Could, perhaps, the fact that it is an invalid index that has no locks on it, and is dependent on the table mean it could be removed by a VACUUM? I just don't like the idea of the user needing to remove broken things. Thom
