Re: [GENERAL] pglogical sync

[armand pirvu]

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

[GENERAL] pglogical sync

[armand pirvu]

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