RE: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl`
Date
Msg-id OSCPR01MB149660172D9F21AA75365DC9BF5EDA@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl`  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl`
List pgsql-hackers
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 Грем.

I'm not sure it could move to 100_bugs.pl. If we do that, 009 test can be removed or
empty?

Best regards,
Hayato Kuroda
FUJITSU LIMITED 


Attachment

pgsql-hackers by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: IO in wrong state on riscv64
Next
From: David Rowley
Date:
Subject: Re: another autovacuum scheduling thread