Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Date: 2025-11-22 14:06:00
Message-ID: CADzfLwV5oQq-Vg_VmG_o4SdL6yHjDoNO4T4pMtgJLzYGmYf74g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, Álvaro!

> Hello, I'm working on getting the 0002 fix committed, with the tests it
> fixes. I ran across this comment:

Nice!

> Am I understanding this correctly?
Yes, you are right. Looks like I mixed up everything while writing the comment.

I attached an updated version, changes are:
1) your fix for comment
2) some updates for 0001 test stability (related to [0]).

I'll recheck other patches too, maybe something needs to be adjusted also.

Best regards,
Mikhail.

[0]: https://www.postgresql.org/message-id/flat/CADzfLwUc%3DjtSUEaQCtyt8zTeOJ-gHZ8%3Dw_KJsVjDOYSLqaY9Lg%40mail.gmail.com

Attachment Content-Type Size
v13-0001-Specs-to-reproduce-the-issues-with-CREATE-INDEX-.patch application/x-patch 49.1 KB
v13-0005-Revert-Doc-cover-index-CONCURRENTLY-causing-erro.patch application/x-patch 1.9 KB
v13-0003-Modify-the-infer_arbiter_indexes-function-to-als.patch application/x-patch 8.1 KB
v13-0004-Modify-the-ExecInitPartitionInfo-function-to-con.patch application/x-patch 6.1 KB
v13-0002-Modify-the-infer_arbiter_indexes-function-to-con.patch application/x-patch 3.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2025-11-22 14:14:27 Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect
Previous Message Jim Jones 2025-11-22 13:16:36 Re: Add notification on BEGIN ATOMIC SQL functions using temp relations