On Fri, 9 Oct 2020 at 15:54, David Christensen <da...@endpoint.com> wrote:
> > 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 target which are being newly > subscribed will be truncated before the data copy step. This saves > explicit coordination of a manual `TRUNCATE` on the target tables and > allows the results of the initial data sync to be the same as on the > publisher at the time of sync. > > To preserve compatibility with existing behavior, the default value for > this parameter is `false`. > > Truncate will fail for tables whose foreign keys refer to it. If such a feature cannot handle foreign keys, the usefulness will be restricted. Regards, -- Euler Taveira http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services