public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dag Lem <[email protected]>
To: [email protected]
Subject: Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing
Date: Fri, 05 Jun 2026 14:35:12 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox