Re: Dropping behavior for unique CONSTRAINTs

2023-03-04 Thread Conner Bean
. Apologies on my misunderstanding!Thanks greatly for your help!Best,CSBOn Mar 3, 2023, at 5:54 AM, David Rowley wrote:On Fri, 3 Mar 2023 at 23:17, Conner Bean wrote:I wanted to avoid using a unique index since dropping them requires anexclusive lock and cannot be done concurrently. My thought was to

Dropping behavior for unique CONSTRAINTs

2023-03-03 Thread Conner Bean
Hi folks,I'm curious if there are any docs supporting the functionality behind dropping unique constraints. For context, I am interested in enforcing uniqueness on a column. This table is heavily used, and I plan on dropping the constraint in the future. I wanted to avoid using a unique index s