Constraints creation with unique lock is too aggressive

[Josipmrden]

Constraints creation with unique lock is too aggressive because a background snapshot creation job can cause this query to throw an exception on not being able to access the unique lock to create the constraints. One option is to allow for read only lock to perform this.

[gitbuda]

This was fixed for indexes, but not for constraints