On Mon, Aug 5, 2019 at 7:34 PM Alex <zhihui.fan1...@gmail.com> wrote: > is this by design?
Yes. Being able to do this is useful for several reasons. For example, it's useful to be able to create a new, equivalent index before dropping the original when the original is bloated. (You could use REINDEX instead, but that has some disadvantages that you might want to avoid.) Questions like this are better suited to the pgsql-general list. -- Peter Geoghegan
