[PATCH] Add `truncate` option to subscription commands

Поиск
Список
Период
Сортировка
От David Christensen
Тема [PATCH] Add `truncate` option to subscription commands
Дата
Msg-id CF3B6672-2A43-4204-A60A-68F359218A9B@endpoint.com
обсуждение исходный текст
Ответы Re: [PATCH] Add `truncate` option to subscription commands  (Amit Kapila <amit.kapila16@gmail.com>)
Re: [PATCH] Add `truncate` option to subscription commands  (Euler Taveira <euler.taveira@2ndquadrant.com>)
Список pgsql-hackers
-hackers,

Enclosed find a patch to add a “truncate” option to subscription commands.

When adding new tables to a subscription (either via `CREATE SUBSCRIPTION` or `REFRESH PUBLICATION`), tables on the
targetwhich are being newly subscribed will be truncated before the data copy step.  This saves explicit coordination
ofa manual `TRUNCATE` on the target tables and allows the results of the initial data sync to be the same as on the
publisherat the time of sync. 

To preserve compatibility with existing behavior, the default value for this parameter is `false`.

Best,

David



--
David Christensen
Senior Software and Database Engineer
End Point Corporation
david@endpoint.com
785-727-1171



Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCH] ecpg: fix progname memory leak