Re: Add into REFRESH PUBLICATION parameter exception_behaviour

On 17/2/26 05:07, Amit Kapila wrote:
> On Mon, Feb 16, 2026 at 6:04 PM Andrei Lepikhov <lepihov(at)gmail(dot)com> wrote:
>> ALTER SUBSCRIPTION mysub
>> REFRESH PUBLICATION (WITH exception_behaviour = ‘skip’);
>>
>
> It will lead to skipping all future changes to that table by apply
> worker as we skip applying till the table is in READY state. So, all
> changes for transactions will get applied but the ones where we
> skipped copy which could lead to inconsistency. I think the better way
> to allow skip copying of initial data for particular tables is to
> someway provision copy_data = off for a set of tables.
Hmm, in my mind, there should be a FAIL table state introduced to let
users know that a specific table has not been synchronised, and they
need to check and repeat a smaller part of the job.
Or do you mean that a synchronising table might already contain some
data, and that it is impossible to undo the sync and repeat it?

--
regards, Andrei Lepikhov,
pgEdge