Re: pgsql: Detach constraints when partitions are detached - Mailing list pgsql-committers

From Amit Langote
Subject Re: pgsql: Detach constraints when partitions are detached
Date
Msg-id d24d40f3-52d7-296c-8e06-5b153c5ba0dd@lab.ntt.co.jp
Whole thread Raw
In response to Re: pgsql: Detach constraints when partitions are detached  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Detach constraints when partitions are detached
Re: pgsql: Detach constraints when partitions are detached
List pgsql-committers
On 2019/01/24 13:58, Tom Lane wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
>> Detach constraints when partitions are detached
> 
> Hm ... it looks like this fails under -DRELCACHE_FORCE_RELEASE:

Oops, sorry.  This is why:

         index_close(idx, NoLock);
...
+        if (!idx->rd_index->indisprimary && !idx->rd_index->indisunique)
+            continue;

Attached a fix.

Thanks,
Amit

Attachment

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Detach constraints when partitions are detached
Next
From: Etsuro Fujita
Date:
Subject: pgsql: postgres_fdw: Account for tlist eval costs inestimate_path_cost