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: Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Date: 2026-01-09 13:26:41
Message-ID: CADzfLwWJD9whA0cY8iCqPsk7PeN=KyomqpTXU4B0j3TDuebUyg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, Álvaro!

On Thu, Jan 8, 2026 at 11:08 AM Mihail Nikalayeu
<mihailnikalayeu(at)gmail(dot)com> wrote:
> I'll try to prepare next set of fixes today/tomorrow:
>
> * In wait_for_idle exit early if we see backend stuck into injection
> point (no sense to wait more, my bad - should be added from the
> start), also reduce timeout to 1/2 of TAP
> * In wait_for_injection_point use 1/2 of TAP timeout.
> * Try to detect install_check in tests and skip instead of whole pack
> * Change year to 2026 :)

Fixes for the fixes are in attachment.

I am not very confident about the second commit, because I am not an
expert in meson/Makefiles.
Some additional explanations are available in commit messages.

Tested with -DCLOBBER_CACHE_ALWAYS=1

I hope this is the last one.

Best regards,
Mikhail.

Attachment Content-Type Size
v1-0001-Fix-wait_for_idle-to-properly-handle-CLOBBER_CACH.patch text/x-patch 3.3 KB
v1-0002-Allow-test_misc-TAP-tests-to-run-during-installch.patch text/x-patch 6.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-01-09 13:37:16 RE: Simplify code building the LR conflict messages
Previous Message Henson Choi 2026-01-09 13:08:13 Re: SQL Property Graph Queries (SQL/PGQ)