Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY
cca5507 <cca5507@qq.com>
From: cca5507 <cca5507@qq.com>
To: surya poondla <suryapoondla4@gmail.com>, Rafia Sabih <rafia.pghackers@gmail.com>
Cc: Giuliano Gagliardi <gogi@gogi.tv>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2026-03-13T07:20:49Z
Lists: pgsql-bugs
Attachments
- v4-0001-Fix-wrong-result-of-refresh-matview-concurrently.patch (application/octet-stream) patch v4-0001
> I think we might want the "*=" operator treat NULL as not equal to NULL and > this is why we add "IS NOT NULL" to the duplicate detection query. > > Your patch treats NULL as equal to NULL, which is different from the SQL > standard, may confuse users. > > So I think we should make the "*=" operator treat NULL as not equal to NULL > or add a new operator to implement it. Thoughts? Attach a patch. I add a new built-in function called record_image_eq_variant which considers two NULLs not equal so that each row can match at most one row during the full join. -- Regards, ChangAo Chen