Re: Is there a work around for partition key needed for constraint - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Is there a work around for partition key needed for constraint
Date
Msg-id 20181025135931.jbo5gnfyd5aliwhu@alvherre.pgsql
Whole thread Raw
In response to Re: Is there a work around for partition key needed for constraint  (Keith Fiske <keith.fiske@crunchydata.com>)
List pgsql-admin
On 2018-Oct-24, Keith Fiske wrote:

> The real solution will have to wait on a global index in a future version.

Actually, there might be another way to implement it, namely to use the
speculative tokens on every affected local btree, then do the actual
insert in the correct index, then remove the unused speculative tokens
from all the other indexes.  Then you don't need a global tree at all.

I'm not planning to work on this, and haven't heard that anyone is.

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


pgsql-admin by date:

Previous
From: Mihalidesová Jana
Date:
Subject: Using pg_basebackup via pgpool fail
Next
From: "Ghiurea, Isabella"
Date:
Subject: upgrade slave in streaming replication from PG 10.4 to 10.5.1