Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY

Hello,

On 2026-Jan-28, Mihail Nikalayeu wrote:

> And about the opposite race + assert (not sure we need to keep it).

I pushed the fix, removing the assert and comment about the whole
scenario.  I'm not sure the assert was doing much, because as I recall,
the index array is populated using the index list obtained from
relcache, which is sorted numerically by OID by definition, so the
assert is pretty much tautological.

I'm unconvinced that there aren't problems in this code related to OID
wraparound for indexes, but I couldn't find any after some testing.
That of course doesn't prove anything.

Many thanks for your efforts here.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)