| Hi folks A question about pglogical sync I have a setup with a schema named myschema. All works well but looking at sync pglogical.alter_subscription_resynchronize_table(subscription_name name, relation regclass) Resynchronize one existing table. WARNING: This function will truncate the table first. Parameters: subscription_name - name of the existing subscription relation - name of existing table, optionally qualified How exactly to you run this ? What am I missing ? testrep=# select pglogical.alter_subscription_resynchronize_table(subscription_name := 'mysubscription', 'myschema.tbl1'); ERROR: positional argument cannot follow named argument LINE 1: ...nize_table(subscription_name := 'mysubscription', 'myschema.... ^ testrep=# select pglogical.alter_subscription_resynchronize_table(subscription_name := 'mysubscription', 'myschema.tbl1'::regclass); ERROR: positional argument cannot follow named argument LINE 1: ...nize_table(subscription_name := 'mysubscription', 'myschema.... Thanks for help Armand |
