Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzb6s-0019FC-2c for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Mar 2026 13:57:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vzb6p-00Gaj0-2N for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Mar 2026 13:57:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzb6p-00Gair-1T for pgsql-bugs@lists.postgresql.org; Mon, 09 Mar 2026 13:57:23 +0000 Received: from mail-qk1-x729.google.com ([2607:f8b0:4864:20::729]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vzb6n-00000001o5p-34IS for pgsql-bugs@lists.postgresql.org; Mon, 09 Mar 2026 13:57:23 +0000 Received: by mail-qk1-x729.google.com with SMTP id af79cd13be357-8cd71fb9f06so174803385a.2 for ; Mon, 09 Mar 2026 06:57:21 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773064640; cv=none; d=google.com; s=arc-20240605; b=dGRW5DS3moFG9VzAD8a15BPdlpftbSSjeq5ZLTDVtIf71Kkrop5ESqp0TWPDuKXaVT xMQSprR9rgvtMLwDtjJt29RQnimAGVvIv06CvTY4fyXB9exeEZ1AUd4ApOn97lQpTaFe bTAV9BRr4jjPpI2SN6wNj9pqGbSMzJ55nKjm6M3LPqaln9c4Pu2r+Z6bOJ3UkGOTkWMG J1+YEYJGxtvRAzetXns+0wx069EhML+pXKyMSJ0Y34xLIfeEOYntwmJN//S7DIKxB299 Fug9LT28TppeBrVmywSa3dR90z838+rkUkVHRB6nm2f/3385Jbyr0BGoiPri0SFvMCKI tlFg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=w0e6Iop0Dl1G0dvl2piSKJaqmG8G/NRtzo2KD1xuWBI=; fh=dvwbYUba9bEFMYQOWwmEaKkCcf4W1aQSyXPFDStXNxU=; b=Xi8dc/bzwfvaWXbdqYyAjrL/YDG+WiurgEtIL+cBdvj3/UtdA+joAyQRqzd5QwM+FS IH+2g68uRI/Aq830Ay0dGBsrEhmR8H19cqG2X1QtBDST4iL8LIOCMmcYiFKliWky2LWw xZngQ2X1i5/7ip91pfyAXUdxDYHOgr1S5ZMtn5TxvHlGGh4YXwrI7foce0N+f6Yrig3H uv6at2Hz0Bvqc66DC0nWLH7UrHOv4AB4TXOXFgPxfvhaMNjhsFoUU/Nbegy9dvR36gs1 lbQ24uNsf+LXgsh16+o7T8zS+9Y7K3IqKSV3h4NZ0AGgZRAwn38UaC3hAREvXnZxxmAX mP1w==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773064640; x=1773669440; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=w0e6Iop0Dl1G0dvl2piSKJaqmG8G/NRtzo2KD1xuWBI=; b=H7ntpVlX84q88VrpNS8hrnoUeQOEDNgf6CvsBOdvCf4Eg8CJf93eRkAHqCVPLG9qGR 2aUzKMYD/NVJ7t6etj2ro6AC1k3qwXY42Lijf0mXYXK8S+YG5NjMNcbBfjFauIcgNj4A NSVJl7KsLp4z+ZXtMWUr4YgO2JwLSyJcDVaFtzl3yjyIbxaTuD7TVbGZ8yMi0yDmyk1h voh74ThEaG3vIvFeAor6nxW0r1V+twhoM/bKE+JsWbaDQ0SRn4VXIu2b8VpwKjl7Yl66 MWgnQQqWIoTy2Ev41NUXz26mYktAkSnYDNez3to7iyNeg5DIBBWgowZOj3IDXRArKuW3 hBVw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773064640; x=1773669440; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=w0e6Iop0Dl1G0dvl2piSKJaqmG8G/NRtzo2KD1xuWBI=; b=dN7L8U3oWDk2FVd/Gk7+Hq+LP+ZDvs60DSYvrQQHI+lXSS3agoAXAv6yL2dD/4dqA/ kEHkiBW++351FOveqSPple381L3v2kRaSJFYJMAsdMudBmFXx/vFzpwFiXIAdeb+zsLz gnscCUJu/kcsDmPNCGyZU7zXwNZHDWM417+IPzFMTdcrkLPWjnH0ao4jVqkFU1kowcsX 8LV0WPjz0ffCdgKSsi5+CLVa0mv343H54r7LXK9oywddCsmIZbjfi6k8n433rGtJocwO fm8ibu/myGt8IVZRa01hfzFsnRxWKsD6oevpWog/C2pKkkymN+3Uz7q4SSde4e+WPs+E A5/g== X-Forwarded-Encrypted: i=1; AJvYcCUedCTG5VAFA0HnFEMNICpvnWXtqBR3xZ1IhyZhtBBT3K264NKgTVZDaarnkWgc3pPLnLC1zV8Q7A0x@lists.postgresql.org X-Gm-Message-State: AOJu0YyZOgv5HUiikiJuRliT/a3q6ZfZbH2nAjIQTAm5m8emTVat/D9w OFZYKBwrNj7VY9xdbgPa6izAOnwscD1gFdxsb6GHI6jAe9YSP7/1qZ/mkttWAxRCbjvqbfeBMs/ rwhuMBtgBTDksdstVd7qx9+ZaQU/hf0E= X-Gm-Gg: ATEYQzykBOg61z367uMbhQRx+41VL05axgahsfh2nCcj52LiygcS7h3tfL2DWfrEg3C S7F7Om9iJs0OriLQ2JPT5SEZpDxSZhDFTZcweDwyzkB8gQzRWFTfi4n2mngDwUdLeiogS3lBBdJ 48loHxUinyn7CGpD7/Xi7QnlPpJFACtJcgEGogGgaO0/hBMIFHUoNN7ioMjAY8AsT4gudkw2AP8 YygIL8OZSiUSlgSbRuCcfnPtay/7yG1By5GUXWnqdk5LxyRfD+wQyXmm6f6Xd96l79DkOjCCqIu jR/gNj8UJf34QsvU77HGPQmlrUSauDPhpEwtHOldfCY+w2cFc/G7Vm8vW5m7BTcmZ1sEpGTpN1+ 315YL X-Received: by 2002:ac8:5690:0:b0:509:59c:579e with SMTP id d75a77b69052e-509059c6e59mr70327011cf.28.1773064639957; Mon, 09 Mar 2026 06:57:19 -0700 (PDT) MIME-Version: 1.0 References: <40d694df-39fd-4a4a-9459-9d6489165f60@gogi.tv> In-Reply-To: From: Rafia Sabih Date: Mon, 9 Mar 2026 06:57:07 -0700 X-Gm-Features: AaiRm50VlUM4_d5I9NP5xFNYAa-wfCzyVuEp_f-XZAXjMbvcbHGhPWJzh702nkw Message-ID: Subject: Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY To: surya poondla Cc: Giuliano Gagliardi , pgsql-bugs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000074d94064c97c84c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000074d94064c97c84c Content-Type: text/plain; charset="UTF-8" In order to take this further, I think it would be good to add this to commitfest. On Wed, 4 Mar 2026 at 17:01, Rafia Sabih wrote: > > > On Mon, 2 Mar 2026 at 14:45, surya poondla > 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 > -- Regards, Rafia Sabih CYBERTEC PostgreSQL International GmbH --000000000000074d94064c97c84c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In order to take this further, I think it would be good to= add this to commitfest.

On Wed, 4 Mar 2026 at 17:01, = Rafia Sabih <rafia.pghacker= s@gmail.com> wrote:

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 th= e test case for NULL values too.

Thank= s for working on this. This looks good to me.=C2=A0
+-- test that= duplicate rows containing NULLs are also detected (bug fix)=C2=A0
I wouldn't use bug fix here, it looks fine without it.


--
Regards,
Rafia Sabih
CYBERTEC PostgreSQL = International GmbH


--
Regards,
Rafia Sabih
CYBERTEC PostgreSQL = International GmbH
--000000000000074d94064c97c84c--