Lines Matching defs:A
20 advisory | 1 | 1 | 2 | ExclusiveLock | t
21 advisory | 2 | 2 | 2 | ShareLock | t
28
31 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
40 pg_advisory_unlock(1, 1), pg_advisory_unlock_shared(2, 2);
41 WARNING: you don't own a lock of type ExclusiveLock
42 WARNING: you don't own a lock of type ShareLock
47 f | f | f | f
48 (1 row)
50 -- automatically release xact locks at commit
52 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
57
71 locktype | classid | objid | objsubid | mode | granted
72 ----------+---------+-------+----------+---------------+---------
73 advisory | 0 | 1 | 1 | ExclusiveLock | t
74 advisory | 0 | 2 | 1 | ShareLock | t
82 pg_advisory_lock | pg_advisory_lock_shared | pg_advisory_lock | pg_advisory_lock_shared
83 ------------------+-------------------------+------------------+-------------------------
85 (1 row)
88 SELECT locktype, classid, objid, objsubid, mode, granted
89 FROM pg_locks WHERE locktype = 'advisory'
103 pg_advisory_unlock(1, 1), pg_advisory_unlock(1, 1),