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 since dropping them requires an exclusive lock and cannot 
be done concurrently. My thought was to then use a unique constraint, since I've read 
unofficial docs[0] that say these can be dropped safely with no lock.However, since a 
unique index would be the backing index to the unique constraint, I'm curious how this 
would work in practice (or if it even does!). Specifically if my theory of: "I can 
use a unique constraint to avoid obtaining an exclusive lock on my table" actually 
works.Thanks for any and all information, it's greatly appreciated, and apologies if I 
missed any existing documentation.Best, CSB0: 
https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql#.ZAEFpezMJLR 

Reply via email to