Re: BUG #16262: pg_advisory_xact_lock cannot be released

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "andy(dot)ye(at)gtssz(dot)net" <andy(dot)ye(at)gtssz(dot)net>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16262: pg_advisory_xact_lock cannot be released
Date: 2020-02-17 13:33:09
Message-ID: 34572581581946389@sas1-17582c8cbad7.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-02-17 13:52:53 BUG #16263: pg_advisory_xact_lock cannot be released
Previous Message PG Bug reporting form 2020-02-17 13:28:40 BUG #16262: pg_advisory_xact_lock cannot be released