Re: pglogical sync

I see says the blind man

Looked in the code

and correct the syntax and ran on subscriber

all good

> On Aug 10, 2017, at 12:29 PM, armand pirvu <armand(dot)pirvu(at)gmail(dot)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
>
>
>