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
|
CREATE OR REPLACE FUNCTION pglogical_ticker.toggle_ext_object(p_type text, p_full_obj_name text, p_toggle text)
RETURNS void
LANGUAGE plpgsql
AS $function$
DECLARE
c_valid_types TEXT[] = ARRAY['EVENT TRIGGER','FUNCTION','VIEW','TABLE'];
c_valid_toggles TEXT[] = ARRAY['ADD','DROP'];
BEGIN
IF NOT (SELECT ARRAY[upper(p_type)] && c_valid_types) THEN
RAISE EXCEPTION 'Must pass one of % as 1st arg.', array_to_string(c_valid_types,',');
END IF;
IF NOT (SELECT ARRAY[upper(p_toggle)] && c_valid_toggles) THEN
RAISE EXCEPTION 'Must pass one of % as 3rd arg.', array_to_string(c_valid_toggles,',');
END IF;
EXECUTE 'ALTER EXTENSION pglogical_ticker '||p_toggle||' '||p_type||' '||p_full_obj_name;
EXCEPTION
WHEN undefined_function THEN
RETURN;
WHEN undefined_object THEN
RETURN;
WHEN object_not_in_prerequisite_state THEN
RETURN;
END;
$function$
;
|
