BUG #16262: pg_advisory_xact_lock cannot be released
Started by PG Bug reporting formabout 6 years ago2 messagesbugs
The following bug has been logged on the website:
Bug reference: 16262
Logged by: andy ye
Email address: andy.ye@gtssz.net
PostgreSQL version: 9.5.18
Operating system: ubuntu 16.04
Description:
When we use the rpc service, the pg_advisory_xact_lock privacy lock cannot
be released. Is there any other solution?
Re: BUG #16262: pg_advisory_xact_lock cannot be released
Hello
This is documented here: https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS
pg_advisory_xact_lock works the same as pg_advisory_lock, except the lock is automatically released at the end of the current transaction and cannot be released explicitly.
regards, Sergei