module Focus::PG::Dsl::AdvisoryLockFunctions

Defined in:

pg/dsl/advisory_lock_functions.cr

Instance Method Summary

Instance Method Detail

def pg_advisory_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression #

[View source]
def pg_advisory_lock(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression #

Session-level exclusive advisory lock


[View source]
def pg_advisory_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression #

[View source]
def pg_advisory_lock_shared(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression #

Session-level shared advisory lock


[View source]
def pg_advisory_unlock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression #

[View source]
def pg_advisory_unlock(key : Focus::IntExpression(Int64)) : Focus::BoolExpression #

Release session-level exclusive advisory lock


[View source]
def pg_advisory_unlock_all : Focus::FunctionExpression #

Release all session-level advisory locks


[View source]
def pg_advisory_unlock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression #

[View source]
def pg_advisory_unlock_shared(key : Focus::IntExpression(Int64)) : Focus::BoolExpression #

Release session-level shared advisory lock


[View source]
def pg_advisory_xact_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression #

[View source]
def pg_advisory_xact_lock(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression #

Transaction-level exclusive advisory lock


[View source]
def pg_advisory_xact_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::FunctionExpression #

[View source]
def pg_advisory_xact_lock_shared(key : Focus::IntExpression(Int64)) : Focus::FunctionExpression #

Transaction-level shared advisory lock


[View source]
def pg_try_advisory_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression #

[View source]
def pg_try_advisory_lock(key : Focus::IntExpression(Int64)) : Focus::BoolExpression #

Try to acquire session-level exclusive advisory lock


[View source]
def pg_try_advisory_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression #

[View source]
def pg_try_advisory_lock_shared(key : Focus::IntExpression(Int64)) : Focus::BoolExpression #

Try to acquire session-level shared advisory lock


[View source]
def pg_try_advisory_xact_lock(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression #

[View source]
def pg_try_advisory_xact_lock(key : Focus::IntExpression(Int64)) : Focus::BoolExpression #

Try to acquire transaction-level exclusive advisory lock


[View source]
def pg_try_advisory_xact_lock_shared(key1 : Focus::IntExpression(Int32), key2 : Focus::IntExpression(Int32)) : Focus::BoolExpression #

[View source]
def pg_try_advisory_xact_lock_shared(key : Focus::IntExpression(Int64)) : Focus::BoolExpression #

Try to acquire transaction-level shared advisory lock


[View source]