pglogical sync
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
I see says the blind man
Looked in the code
and correct the syntax and ran on subscriber
all good
Show quoted text
On Aug 10, 2017, at 12:29 PM, armand pirvu <armand.pirvu@gmail.com> wrote:
Hi folks
A question about pglogical sync
I have a setup with a schema named myschema.
All works well but looking at syncpglogical.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 qualifiedHow 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