| From: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
|---|---|
| To: | 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Грем Снорт <grem(dot)snoort(at)gmail(dot)com> |
| Subject: | RE: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` |
| Date: | 2025-10-12 05:59:14 |
| Message-ID: | OSCPR01MB149660172D9F21AA75365DC9BF5EDA@OSCPR01MB14966.jpnprd01.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| 0001-Fix-009_mateviews.pl.patch | application/octet-stream | 3.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2025-10-12 06:27:10 | Re: another autovacuum scheduling thread |
| Previous Message | Alexander Lakhin | 2025-10-12 05:00:00 | Re: IO in wrong state on riscv64 |