On Fri, Dec 9, 2022 at 8:57 AM li jie <ggysxcq@gmail.com> wrote:
>
> It is worth considering whether temporary objects, such as tables,
> indexes, and sequences,
> should be replicated to the subscriber side.
>
> Like temp tables, different sessions create their own temp tables.
> If they are all transferred to the subscriber side, there will
> inevitably be errors,
> because there is only one subscription session.
>
> I think temporary objects should not be part of replication because
> they are visible within the session.
> replicate them over would not make them visible to the user and would
> not be meaningful.
>
I also don't think we should replicate temp tables. We anyway don't
replicate their data.
--
With Regards,
Amit Kapila.