6.3. Advisory Lock Functions #
Advisory locks are cluster-wide locks with no enforced use. Here is a list of functions to work with these locks.
Table 6.1. Advisory Lock Functions
| Function | Returns |
|---|---|
shardman.advisory_xact_lock(key64 BIGINT); | void |
shardman.advisory_xact_lock_shared(key64 BIGINT); | void |
shardman.try_advisory_xact_lock(key64 BIGINT); | bool |
shardman.try_advisory_xact_lock_shared(key64 BIGINT); | bool |
shardman.advisory_xact_lock(key1 INT, key2 INT); | void |
shardman.advisory_xact_lock_shared(key1 INT, key2 INT); | void |
shardman.try_advisory_xact_lock(key1 INT, key2 INT); | bool |
shardman.try_advisory_xact_lock_shared(key1 INT, key2 INT); | bool |