Date: Wed, 10 Oct 2018 13:47:28 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: mikemjv@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15425: DETACH/ATTACH PARTITION bug
Message-ID: <20181010164728.ymzfjw6loxj6flx6@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <15425-2dbc9d2aa999f816@postgresql.org>
User-Agent: NeoMutt/20180716
Precedence: bulk

On 2018-Oct-10, PG Bug reporting form wrote:

> After I DETACH a partition, and then try to ATTACH it again, I get errors:
> ERROR:  duplicate key value violates unique constraint
> "pg_constraint_conrelid_contypid_conname_index"
> DETAIL:  Key (conrelid, contypid, conname)=(26702, 0,
> test_result_asset_id_fkey) already exists.
> 
> It looks like it is trying to add the foreign key again.

Thanks.  Reproduced with

create table main (a int primary key);
create table part (a int references main) partition by range (a);
create table part1 partition of part for values from (1) to (100);
alter table part detach partition part1;
alter table part attach partition part1 for values from (1) to (100);

Looking into it.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services