Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] pglogical sync - Mailing list pgsql-general

From armand pirvu
Subject Re: [GENERAL] pglogical sync
Date
Msg-id 53D59196-0CC6-4F43-B46E-E258BF560964@gmail.com
Whole thread Raw
In response to [GENERAL] pglogical sync  (armand pirvu <armand.pirvu@gmail.com>)
List pgsql-general
Tree view
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.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




pgsql-general by date:

Previous
From: armand pirvu
Date:
Subject: [GENERAL] Re: could not find function "pglogical_table_data_filtered" in file"/usr/pgsql-9.5/lib/pglogical.so"
Next
From: marcelo
Date:
Subject: [GENERAL] sequence used on null value or get the max value for a column whithconcurrency