On Fri, Dec 9, 2022 at 8:57 AM li jie <ggys...@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.