On Sat, 4 Mar 2023 at 10:55, Ron <ronljohnso...@gmail.com> wrote: > On 3/3/23 04:54, David Rowley wrote: > If you have a look at > https://www.postgresql.org/docs/15/sql-dropindex.html check out the > CONCURRENTLY option. That option allows an index to be dropped without > blocking concurrent reads and writes to the table. It seems like just > having a unique index without the constraint is likely your best bet > if you can't afford to block any traffic for the brief moment it would > take to drop the constraint. > > > That doc page says this about CONCURRENTLY: > " > There are several caveats to be aware of when using this option. Only one > index name can be specified, and the CASCADE option is not supported. (Thus, > an index that supports a UNIQUE or PRIMARY KEY constraint cannot be dropped > this way.) > "
I'm not sure which one of these you think applies to the recommendation I mentioned or if you were just generally highlighting the limitations of DROP INDEX CONCURRENTLY. David