MIME-Version: 1.0
References: <40d694df-39fd-4a4a-9459-9d6489165f60@gogi.tv> <CAOVWO5p7PieGTm3GJC8NAYgSEQLoBdZw9Se4u=EbPrr1mW7d5Q@mail.gmail.com>
 <CAOVWO5rWkGXx37tpsAuTwrY5muPePHG44ke0xwYcakWVfhkPaw@mail.gmail.com>
 <CAOVWO5qchazoL8H+-d4eZ_zm8jFUH4YF3WvWnXqcDEh8i7hbhw@mail.gmail.com>
 <CAOVWO5qF2_FV7M=USdSgjjPO124YMpw7TY+M4+mnkNPOA2Bstg@mail.gmail.com>
 <CA+FpmFe7pgJRi16zP8Liz5vuUkVdTnPy30Zr=mXzZA3shKgvCw@mail.gmail.com>
 <CAOVWO5rfJGpxRDn496gAHmAxW7L_72==KkOcz0q16YOvqm4-=g@mail.gmail.com> <CAOVWO5p2U8rMvh3pJ4WaNN7ES4SbiEKXLV_0pZ-UdYp0kACa7g@mail.gmail.com>
In-Reply-To: <CAOVWO5p2U8rMvh3pJ4WaNN7ES4SbiEKXLV_0pZ-UdYp0kACa7g@mail.gmail.com>
From: Rafia Sabih <rafia.pghackers@gmail.com>
Date: Wed, 4 Mar 2026 17:01:34 -0800
Message-ID: <CA+FpmFeLJDWZSx1TSRVodFbQOLWa-SXBCiG0rspu--HtadaJ+w@mail.gmail.com>
Subject: Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY
To: surya poondla <suryapoondla4@gmail.com>
Cc: Giuliano Gagliardi <gogi@gogi.tv>, pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000435c7064c3c7b10"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFpmFeLJDWZSx1TSRVodFbQOLWa-SXBCiG0rspu--HtadaJ%2Bw%40mail.gmail.com>
Precedence: bulk

--0000000000000435c7064c3c7b10
Content-Type: text/plain; charset="UTF-8"

On Mon, 2 Mar 2026 at 14:45, surya poondla <suryapoondla4@gmail.com> wrote:

> Hi All,
>
> Thank you Rafia for the suggestions.
> I split both the bugs in 2 different commits, attaching the patches here.
>
> For bug1, I added the test case for NULL values too.
>
> Thanks for working on this. This looks good to me.
+-- test that duplicate rows containing NULLs are also detected (bug fix)
I wouldn't use bug fix here, it looks fine without it.

>

-- 
Regards,
Rafia Sabih
CYBERTEC PostgreSQL International GmbH

--0000000000000435c7064c3c7b10
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 2 Mar 2026 a=
t 14:45, surya poondla &lt;<a href=3D"mailto:suryapoondla4@gmail.com" targe=
t=3D"_blank">suryapoondla4@gmail.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi All,<br><br>Th=
ank you Rafia for the suggestions.<br>I split both the bugs in 2 different =
commits, attaching the patches here.<br><br>For bug1, I added the test case=
 for NULL values too.<br><br></div></div></blockquote><div>Thanks for worki=
ng on this. This looks good to me.=C2=A0</div><div>+-- test that duplicate =
rows containing NULLs are also detected (bug fix)=C2=A0</div><div>I wouldn&=
#39;t use bug fix here, it looks fine without it.</div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex">
</blockquote></div></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Regards,<br>Rafia Sabih<div>CYBERTEC PostgreSQL =
International GmbH<br></div></div></div></div>
</div>

--0000000000000435c7064c3c7b10--