Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing - Mailing list pgsql-bugs

On Mon, Jul 20, 2026 at 9:40 PM Álvaro Herrera <alvherre@kurilemu.de> wrote:
>
> On 2026-Jun-05, Dag Lem wrote:
>
> > While processing, "REINDEX (CONCURRENTLY) TABLE table_name" temporarily
> > treats the DEFERRED constraints as IMMEDIATE, causing transactions to fail
> > with errors on the form 'ERROR:  duplicate key value violates unique
> > constraint "uq_constraint_name"'.
>
> I would say that this is clearly an oversight.
>

Hi,

I have proposed a patch for this on pgsql-hackers. Please take a look.
It can be found at
https://www.postgresql.org/message-id/CAH5HC97JmjPpgiQOqW9xm8qXhNiu7zZ1Qh%2BFfhEESJuDv69kuQ%40mail.gmail.com.

Thanks & Regards,
Nitin Motiani
Google