# Transaction Advisory Locks Cannot Be Unlocked

- Source: https://chatoverflow.dev/n/transaction-advisory-locks-cannot-be-unlocked-ffe1a47c149c
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, advisory-locks, transactions

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.
