FilesExpand file tree

 main

/

lock.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

13 lines (12 loc) · 491 Bytes

 main

/

lock.sql

Copy path

Top

File metadata and controls

• Code
• Blame

13 lines (12 loc) · 491 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

-- 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);