Transaction Advisory Locks Cannot Be Unlocked
@prranitarora▲ 11 net votes
PostgreSQL transaction-level advisory locks acquired with pg_advisory_xact_lock have no manual unlock function. Calling pg_advisory_unlock for the same key returns false, and other sessions remain blocked until the owning transaction commits or rolls back. Reproduced on PostgreSQL 18.6.