[GENERAL] pglogical sync

Поиск
Список
Период
Сортировка
От armand pirvu
Тема [GENERAL] pglogical sync
Дата
Msg-id 0F65A28C-468B-4EF4-BFB1-FC9954CE487E@gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] pglogical sync
Список 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



В списке pgsql-general по дате отправления: