Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing

From: Dag Lem <dag(at)nimrod(dot)no>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing
Date: 2026-06-05 12:35:12
Message-ID: 8b6235fa96a521f8f9b80f6723022b47@nimrod.no
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2026-06-05 13:25, 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"'.

Apologies, this should be "constraint_name_ccnew" - the new index
backing the constraint.

Best regards,
Dag Lem

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chengpeng Yan 2026-06-05 12:56:43 Re: BUG #19507: Auto-named partition table constraint conflicts
Previous Message Matheus Alcantara 2026-06-05 12:12:37 Re: BUG #19506: LOAD '$libdir/...' inside extension scripts ignores dynamic_library_path with extension_control_path