| From: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | pglogical sync |
| Date: | 2017-08-10 17:29:43 |
| Message-ID: | 0F65A28C-468B-4EF4-BFB1-FC9954CE487E@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | armand pirvu | 2017-08-10 17:30:49 | pglogical repo |
| Previous Message | Tom Lane | 2017-08-10 15:09:26 | Re: Curious planning decision |