Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gFgAm-00087F-De
	for pgsql-admin@arkaria.postgresql.org; Thu, 25 Oct 2018 13:59:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gFgAk-00016u-HL
	for pgsql-admin@arkaria.postgresql.org; Thu, 25 Oct 2018 13:59:38 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1gFgAk-00016m-9X
	for pgsql-admin@lists.postgresql.org; Thu, 25 Oct 2018 13:59:38 +0000
Received: from mail-qt1-x831.google.com ([2607:f8b0:4864:20::831])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1gFgAh-0007A6-NC
	for pgsql-admin@postgresql.org; Thu, 25 Oct 2018 13:59:37 +0000
Received: by mail-qt1-x831.google.com with SMTP id j46-v6so9907480qtc.9
        for <pgsql-admin@postgresql.org>;
 Thu, 25 Oct 2018 06:59:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=GjNjXEh2EUt+FAQQ4EdIyouC+OhOB564FoBz6VfXGXE=;
        b=TSHqSniFtoThrkSBxBqEaTSolPJXYf05ke/lbWCbLGzI84l1/U30WFBcWsPBltzTIc
         9snRJ/k0K2Yv1y9VeLuUab59CnLuenJ897f1MmpSbL+Uav4UWkiGlOCZtSZpGoOdTRrn
         LmbWjTdjDuUe/mBJUY2Kr0p8hpCGrdg4i6i5uw2LQ/tZD5SqS+2CDdOxiJIT4+XTDGlL
         AYGuA+j26FWqIL0KkdYMURheXbkegPavybdyBOML1bC5sxDK4/MgxVMAUPWjXEIyCPCw
         CNEIqDeHvbwF934BA1MjFrCfeTdzhrQjBfyAGxlBrxuD59mUIgIcZuVCOnDO0/X7ttUc
         fcaA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=GjNjXEh2EUt+FAQQ4EdIyouC+OhOB564FoBz6VfXGXE=;
        b=ELBf56y15rH4wTY15vhqfbiJH2WVxODHeDnRi70jen0vCILnouHAXxSwLyYyvJGo69
         a08WaezVdRRB9ZCgtUs/GiAQsr0vXDShrIs65JEs4jYd3Zes/tBwtGhIif/0JF7s4koo
         XwzUewf3POmdhbn+shiH6bnPrDUrhVGBLmvArIxR2CDTYEDPhFey2sJ1F06FkcNV+Bza
         7sR4qWxuewQ1xjwzaBtsSq69OGifcD9lsjjuIAFajbQmr8xI0+wbk4FVkQz8hs0xDCVj
         vJsa6bM26aXUH0h3TuVrbnxL74RsE8a7QgyWU4txFmd7H8soELY6R4DeqWESlk3wJXqh
         iLkA==
X-Gm-Message-State: AGRZ1gIYKIP5m8ejpZQsug85kr7xTSIgR/5euBwCegLffSZ2QKI3Ws3/
	1Co5m88dZV7TbjrFNwctyCrqeEpsIDg=
X-Google-Smtp-Source: 
 AJdET5f2hIKFyZQ86KyV5gGN/zgHw3aY+UFMfynlvU+6za61+/vVgep4CKCjSolnvkqXNpfTqnjUVQ==
X-Received: by 2002:ac8:33d3:: with SMTP id
 d19-v6mr1562300qtb.82.1540475974175;
        Thu, 25 Oct 2018 06:59:34 -0700 (PDT)
Received: from alvin.alvh.no-ip.org ([190.121.29.3])
        by smtp.gmail.com with ESMTPSA id
 46-v6sm6617517qtv.73.2018.10.25.06.59.33
        (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256);
        Thu, 25 Oct 2018 06:59:33 -0700 (PDT)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
	id B68E1631; Thu, 25 Oct 2018 10:59:31 -0300 (-03)
Date: Thu, 25 Oct 2018 10:59:31 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Keith Fiske <keith.fiske@crunchydata.com>
Cc: Jorge Torralba <jorge.torralba@gmail.com>, legrand_legrand@hotmail.com,
	pgsql-admin@postgresql.org
Subject: Re: Is there a work around for partition key needed for constraint
Message-ID: <20181025135931.jbo5gnfyd5aliwhu@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAODZiv7+Hf+b+W0Q34=j1W6HwbAOkxzxGoc5HDS9HB8OVva65w@mail.gmail.com>
User-Agent: NeoMutt/20180716
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

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