1
SET client_min_messages = warning;
2
SELECT pglogical.replication_set_add_table(
3
set_name:='my_special_tables_1'
4
,relation:='special.foo'::REGCLASS);
5
replication_set_add_table
6
---------------------------
10
SELECT pglogical.replication_set_add_table(
11
set_name:='my_special_tables_2'
12
,relation:='special.bar'::REGCLASS);
13
replication_set_add_table
14
---------------------------
19
SELECT pgl_ddl_deploy.deploy('my_special_tables_1');
25
SELECT pgl_ddl_deploy.deploy('my_special_tables_2');
31
--Ensure these kinds of configs only have 'create' event triggers
33
FROM pg_event_trigger evt
34
INNER JOIN pgl_ddl_deploy.event_trigger_schema ets
35
ON evt.evtname IN(auto_replication_unsupported_trigger_name,
36
ets.auto_replication_drop_trigger_name,
37
ets.auto_replication_create_trigger_name)
38
WHERE include_only_repset_tables;
45
SELECT pgl_ddl_deploy.deploy(id)
46
FROM pgl_ddl_deploy.set_configs
47
WHERE set_name = 'my_special_tables_1';
53
SELECT pgl_ddl_deploy.deploy(id)
54
FROM pgl_ddl_deploy.set_configs
55
WHERE set_name = 'my_special_tables_2';