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
|
create or replace function londiste.set_session_replication_role(val text, is_local bool) returns void as $$
begin
if is_local then
if val = 'origin' then
set local session_replication_role = 'origin';
elsif val = 'replica' then
set local session_replication_role = 'replica';
elsif val = 'local' then
set local session_replication_role = 'local';
else
raise exception 'bad value for session_replication_role';
end if;
else
if val = 'origin' then
set session_replication_role = 'origin';
elsif val = 'replica' then
set session_replication_role = 'replica';
elsif val = 'local' then
set session_replication_role = 'local';
else
raise exception 'bad value for session_replication_role';
end if;
end if;
end;
$$ language plpgsql security definer;
|
