On Mon, Oct 13, 2025 at 5:18 PM Amit Kapila <[email protected]> wrote: > > On Sun, Oct 12, 2025 at 11:29 AM Hayato Kuroda (Fujitsu) > <[email protected]> wrote: > > > > Dear Amit, Ashutosh, > > > > > Thanks for the analysis. I think we should go with the simple patch > > > proposed in this thread to improve this test and that too only for > > > HEAD. > > > > To confirm, are you suggesting something like attached? It initially > > creates MVs > > on both instances, then ensure REFRESH MATERIALIZED VIEW won't be > > replicated. > > It also fixed the issue reported by Грем. > > > > What difference REFRESH will make instead of CREATE? I think it is > okay to just patch what is posted by the reporter in the first email > [1] in this thread. > > [1]: > https://www.postgresql.org/message-id/CANV9Qw5HD7%3DFp4nox2O7DoVctHoabRRVW9Soo4A%3DQipqW5B%3DTg%40mail.gmail.com
For now this makes sense. We could avoid running a full test, and save time and resources, if we piggy back MV vs logical replication testing on 100_bugs.pl. If we do that, it should be master-only and can be a separate discussion. -- Best Wishes, Ashutosh Bapat
