coder/coderd/database/queries/lock.sql at graphite-base/25577 · coder/coder

13 lines (12 loc) · 491 Bytes

-- name: AcquireLock :exec
-- Blocks until the lock is acquired.
--
-- This must be called from within a transaction. The lock will be automatically
-- released when the transaction ends.
SELECT pg_advisory_xact_lock($1);

-- name: TryAcquireLock :one
-- Non blocking lock. Returns true if the lock was acquired, false otherwise.
--
-- This must be called from within a transaction. The lock will be automatically
-- released when the transaction ends.
SELECT pg_try_advisory_xact_lock($1);

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Expand file tree

Search code, repositories, users, issues, pull requests...

Uh oh!

FilesExpand file tree

lock.sql

Latest commit

History

lock.sql

File metadata and controls

Expand file tree