Functions / System Administration Functions

pg_advisory_unlock_all

Releases all session-level advisory locks held by the current session.

Reading PG 18current·documented in 21 of 27 versions, 8.2 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_advisory_unlock_all () → void

Releases all session-level advisory locks held by the current session. (This function is implicitly invoked at session end, even if the client disconnects ungracefully.)

Version history 3

12 → 13 changed
9.0 → 9.1 changed
8.1 → 8.2 added

Definition snapshot: b7bd9cda · English manual source