1CREATE OR REPLACE FUNCTION pglogical.create_subscription(subscription_name name, provider_dsn text,
2    replication_sets text[] = '{default,default_insert_only,ddl_sql}', synchronize_structure boolean = true,
3    synchronize_data boolean = true, forward_origins text[] = '{all}')
4RETURNS oid STRICT VOLATILE LANGUAGE c AS 'MODULE_PATHNAME', 'pglogical_create_subscription';
5
6DO $$
7BEGIN
8	IF (SELECT count(1) FROM pglogical.node) > 0 THEN
9		SELECT * FROM pglogical.create_replication_set('ddl_sql', true, false, false, false);
10	END IF;
11END; $$;
12
13UPDATE pglogical.subscription SET sub_replication_sets = array_append(sub_replication_sets, 'ddl_sql');
14
15WITH applys AS (
16	SELECT sub_name FROM pglogical.subscription WHERE sub_enabled
17),
18disable AS (
19	SELECT pglogical.alter_subscription_disable(sub_name, true) FROM applys
20)
21SELECT pglogical.alter_subscription_enable(sub_name, true) FROM applys;
22