module

Focus::PG::Dsl::AdvisoryLockFunctions

Instance methods

pg_advisory_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression
Source
pg_advisory_lock(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression

Session-level exclusive advisory lock

Source
pg_advisory_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression
Source
pg_advisory_lock_shared(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression

Session-level shared advisory lock

Source
pg_advisory_unlock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression
Source
pg_advisory_unlock(key : Focus::IntExpression(Int64)) : Focus::BoolExpression

Release session-level exclusive advisory lock

Source
pg_advisory_unlock_all

Release all session-level advisory locks

Source
pg_advisory_unlock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression
Source
pg_advisory_unlock_shared(key : Focus::IntExpression(Int64)) : Focus::BoolExpression

Release session-level shared advisory lock

Source
pg_advisory_xact_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression
Source
pg_advisory_xact_lock(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression

Transaction-level exclusive advisory lock

Source
pg_advisory_xact_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression
Source
pg_advisory_xact_lock_shared(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression

Transaction-level shared advisory lock

Source
pg_try_advisory_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression
Source
pg_try_advisory_lock(key : Focus::IntExpression(Int64)) : Focus::BoolExpression

Try to acquire session-level exclusive advisory lock

Source
pg_try_advisory_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression
Source
pg_try_advisory_lock_shared(key : Focus::IntExpression(Int64)) : Focus::BoolExpression

Try to acquire session-level shared advisory lock

Source
pg_try_advisory_xact_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression
Source
pg_try_advisory_xact_lock(key : Focus::IntExpression(Int64)) : Focus::BoolExpression

Try to acquire transaction-level exclusive advisory lock

Source
pg_try_advisory_xact_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression
Source
pg_try_advisory_xact_lock_shared(key : Focus::IntExpression(Int64)) : Focus::BoolExpression

Try to acquire transaction-level shared advisory lock

Source