pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16262: pg_advisory_xact_lock cannot be released
2+ messages / 2 participants
[nested] [flat]
* BUG #16262: pg_advisory_xact_lock cannot be released
@ 2020-02-17 13:28 PG Bug reporting form <noreply@postgresql.org>
2020-02-17 13:33 ` Re: BUG #16262: pg_advisory_xact_lock cannot be released Sergei Kornilov <sk@zsrv.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2020-02-17 13:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: andy.ye@gtssz.net
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16262: pg_advisory_xact_lock cannot be released
2020-02-17 13:28 BUG #16262: pg_advisory_xact_lock cannot be released PG Bug reporting form <noreply@postgresql.org>
@ 2020-02-17 13:33 ` Sergei Kornilov <sk@zsrv.org>
0 siblings, 0 replies; 2+ messages in thread
From: Sergei Kornilov @ 2020-02-17 13:33 UTC (permalink / raw)
To: andy.ye@gtssz.net <andy.ye@gtssz.net>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-02-17 13:33 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-17 13:28 BUG #16262: pg_advisory_xact_lock cannot be released PG Bug reporting form <noreply@postgresql.org>
2020-02-17 13:33 ` Sergei Kornilov <sk@zsrv.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox