Re: CREATE INDEX CONCURRENTLY on partitioned index - Mailing list pgsql-hackers

From Alexander Pyhalov
Subject Re: CREATE INDEX CONCURRENTLY on partitioned index
Date
Msg-id 6472861e485554974ff40375e6d4b81a@postgrespro.ru
Whole thread
In response to Re: CREATE INDEX CONCURRENTLY on partitioned index  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Alexander Pyhalov писал(а) 2025-07-01 09:43:
> Ilya Gladyshev писал(а) 2024-07-13 01:17:
>> On 12.07.2024 01:01, Michael Paquier wrote:
>> 
>>> Please let's move this point to its own thread and deal with it with
>>> an independent patch.  Hiding that in a thread that's already quite
>>> long is not a good idea.  This needs proper review, and a separate
>>> thread with a good subject to describe the problem will attract a
>>> better audience to deal with the problem you are seeing.
>>> 
>>> I was not paying much attention, until you've mentioned that this
>>> was
>>> an issue with HEAD.
>>> --
>>> Michael
>> 
>> Sure, created a separate thread [1]. Please disregard the second patch
>> in this thread. Duplicating the last version of the relevant patch
>> here to avoid any confusion.
>> 
>> [1]
>> https://www.postgresql.org/message-id/b72f2d89-820a-4fa2-9058-b155cf646f4f%40gmail.com
> 
> Hi. We've found an issue with this patch. CIC can pop last active 
> snapshot when operating on partitioned table without leaves. This seems 
> to be similar to the issue, fixed by
...

Hi.
The patch evidently fails to do concurrent index creation on master, as 
childStmt looses "concurrent" property.
Attaching fixed patch.

-- 
Best regards,
Alexander Pyhalov,
Postgres Professional
Attachment

pgsql-hackers by date:

Previous
From: Ilmar Y
Date:
Subject: Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement
Next
From: Andres Freund
Date:
Subject: Re: Add RISC-V Zbb popcount optimization