sql/lock.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

SELECT
    locktype,
    relation::regclass,
    mode,
    transactionid AS tid,
    virtualtransaction AS vtid,
    pid,
    granted
FROM
    pg_catalog.pg_locks l
    LEFT JOIN pg_catalog.pg_database db ON db.oid = l.database
WHERE (db.datname = 'dawndb'
    OR db.datname IS NULL)
AND NOT pid = pg_backend_pid();