regress/expected/advisory_lock.out

14 	FROM pg_locks WHERE locktype = 'advisory'
18  advisory |       0 |     1 |        1 | ExclusiveLock | t
19  advisory |       0 |     2 |        1 | ShareLock     | t
20  advisory |       1 |     1 |        2 | ExclusiveLock | t
21  advisory |       2 |     2 |        2 | ShareLock     | t
31 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
52 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
69 	FROM pg_locks WHERE locktype = 'advisory'
73  advisory |       0 |     1 |        1 | ExclusiveLock | t
74  advisory |       0 |     2 |        1 | ShareLock     | t
75  advisory |       1 |     1 |        2 | ExclusiveLock | t
76  advisory |       2 |     2 |        2 | ShareLock     | t
89 	FROM pg_locks WHERE locktype = 'advisory'
93  advisory |       0 |     1 |        1 | ExclusiveLock | t
94  advisory |       0 |     2 |        1 | ShareLock     | t
95  advisory |       1 |     1 |        2 | ExclusiveLock | t
96  advisory |       2 |     2 |        2 | ShareLock     | t
114 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
131 	FROM pg_locks WHERE locktype = 'advisory'
135  advisory |       0 |     1 |        1 | ExclusiveLock | t
136  advisory |       0 |     2 |        1 | ShareLock     | t
137  advisory |       1 |     1 |        2 | ExclusiveLock | t
138  advisory |       2 |     2 |        2 | ShareLock     | t
151 	FROM pg_locks WHERE locktype = 'advisory'
155  advisory |       0 |     1 |        1 | ExclusiveLock | t
156  advisory |       0 |     2 |        1 | ShareLock     | t
157  advisory |       1 |     1 |        2 | ExclusiveLock | t
158  advisory |       2 |     2 |        2 | ShareLock     | t
168 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
187 	FROM pg_locks WHERE locktype = 'advisory'
191  advisory |       0 |     1 |        1 | ExclusiveLock | t
192  advisory |       0 |     2 |        1 | ShareLock     | t
193  advisory |       1 |     1 |        2 | ExclusiveLock | t
194  advisory |       2 |     2 |        2 | ShareLock     | t
198 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
216 	FROM pg_locks WHERE locktype = 'advisory'
220  advisory |       0 |     1 |        1 | ExclusiveLock | t
221  advisory |       0 |     2 |        1 | ShareLock     | t
222  advisory |       1 |     1 |        2 | ExclusiveLock | t
223  advisory |       2 |     2 |        2 | ShareLock     | t
236 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';
254 	FROM pg_locks WHERE locktype = 'advisory'
258  advisory |       0 |     1 |        1 | ExclusiveLock | t
259  advisory |       0 |     2 |        1 | ShareLock     | t
260  advisory |       1 |     1 |        2 | ExclusiveLock | t
261  advisory |       2 |     2 |        2 | ShareLock     | t
270 SELECT count(*) FROM pg_locks WHERE locktype = 'advisory';