1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
|
\set VERBOSITY 'terse'
set client_min_messages = 'warning';
show session_replication_role;
session_replication_role
--------------------------
origin
(1 row)
select pgq.create_queue('role_test_enabled');
create_queue
--------------
1
(1 row)
select pgq.create_queue('role_test_disabled');
create_queue
--------------
1
(1 row)
update pgq.queue set queue_disable_insert=true where queue_name = 'role_test_disabled';
select pgq.insert_event('role_test_enabled', 'enabled', 'role:origin');
insert_event
--------------
1
(1 row)
select pgq.insert_event('role_test_disabled', 'disabled', 'role:origin');
ERROR: Insert into queue disallowed
set session_replication_role = 'replica';
show session_replication_role;
session_replication_role
--------------------------
replica
(1 row)
select pgq.insert_event('role_test_enabled', 'enabled', 'role:replica');
insert_event
--------------
2
(1 row)
select pgq.insert_event('role_test_disabled', 'disabled', 'role:replica');
insert_event
--------------
2
(1 row)
set session_replication_role = 'local';
show session_replication_role;
session_replication_role
--------------------------
local
(1 row)
select pgq.insert_event('role_test_enabled', 'enabled', 'role:local');
insert_event
--------------
3
(1 row)
select pgq.insert_event('role_test_disabled', 'disabled', 'role:local');
ERROR: Insert into queue disallowed
set session_replication_role = 'origin';
show session_replication_role;
session_replication_role
--------------------------
origin
(1 row)
select pgq.insert_event('role_test_enabled', 'enabled', 'role:origin');
insert_event
--------------
4
(1 row)
select pgq.insert_event('role_test_disabled', 'disabled', 'role:origin');
ERROR: Insert into queue disallowed
select pgq.drop_queue('role_test_enabled');
drop_queue
------------
1
(1 row)
select pgq.drop_queue('role_test_disabled');
drop_queue
------------
1
(1 row)
|