Re: [GENERAL] pglogical sync

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 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