Request a Demo
Home   >   mailing lists

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

From Dag Lem
Subject Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing
Date
Msg-id 8b6235fa96a521f8f9b80f6723022b47@nimrod.no
Whole thread
In response to REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing  (Dag Lem <dag@nimrod.no>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

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