Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1gUwU3-0006o2-P5
	for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Dec 2018 16:26: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-hackers-owner+archive@lists.postgresql.org>)
	id 1gUwU2-00049V-Bg
	for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Dec 2018 16:26:38 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1gUwU1-000496-Ui
	for pgsql-hackers@lists.postgresql.org; Thu, 06 Dec 2018 16:26:38 +0000
Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1gUwTy-0006rq-2i
	for pgsql-hackers@lists.postgresql.org; Thu, 06 Dec 2018 16:26:36 +0000
Received: by mail-qt1-x843.google.com with SMTP id r14so1184587qtp.1
        for <pgsql-hackers@lists.postgresql.org>;
 Thu, 06 Dec 2018 08:26:33 -0800 (PST)
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=kjp6vV19Jf8jcFKyLX/0n4gcIxDR/wG05cuIkzsE8ok=;
        b=gYmkK9owO4VxfXPPGrov58I/Yn/lieJnI3DIKYGjR1emuGZfd85RzeDc/+g/TLiFwp
         kHttrsyfdc+kQYF0JGlMlJPtLU/y0vB00ifGjYDTQgik4wshQibXF4PHG6Ricr9GIFr3
         BnfVewsJCkSlzjUjQXvYdnq8HBnsz5jEw3P98iEccUG0rgpm9CgYhfExhPtZhXsYZcb1
         u+frJ1fmwjnVKWKIW5aqXXfFr05W0l93nzzhDFHKBsL9esuVryPrlb9wHJyvLZ5XmFc+
         zfPCFoQN1NPB+04rEs6L0AKj1fiEvb03AWlMwUrVOT6b2p1mrd4caIzwHIUsLy3M3AF+
         X5ug==
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=kjp6vV19Jf8jcFKyLX/0n4gcIxDR/wG05cuIkzsE8ok=;
        b=ofhbfd6JBtBXwcsJEZQ1A99R68IIZFJUiDVXEI9IsIfRjD/Q55ojBcokvm4IAlDnki
         kQSoVMpymjtpFwmN2pzEEtpI1oQB72hnhcUbtP+onpcl1kTcbjGea/WTTbg1jc1m3EE7
         ahhVgCLJA9rV8H7iquGrjMZzIy2Ff/cgigCoqokXPWJHaCjO5n3PRKXCq+6Zfl5Wohzf
         sES9PIZJE+PVQic54TOHo1sbY+qnhBOSLjXSBo+Y/1FlcAHBlTLM/RKB3ScQaHfCn82K
         TnbYzyMkyEI1qyC4feC1myNEjQF07xur7vxy53DfAgiTmt16LpoDrpeGnNcMBzMy9Fh0
         AQBQ==
X-Gm-Message-State: AA+aEWaHBXexCXoOGN1z/anC5Dh7Jooa1DPx1ijLrmDkUxk5DPBV3wG3
	mRkWd0xdHHD9WM9A65gDiPU41g==
X-Google-Smtp-Source: 
 AFSGD/VqNhKkWIz5j2Ug+z7YCUZnh+z8uY+fOB9Q64xJUzqQqs4Vzh0kMRslVc4vQh9OTiZubU0hkw==
X-Received: by 2002:a0c:cc8c:: with SMTP id
 f12mr28268015qvl.102.1544113592636;
        Thu, 06 Dec 2018 08:26:32 -0800 (PST)
Received: from alvin.alvh.no-ip.org ([190.121.29.3])
        by smtp.gmail.com with ESMTPSA id
 x49sm608161qta.89.2018.12.06.08.26.31
        (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256);
        Thu, 06 Dec 2018 08:26:32 -0800 (PST)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
	id 224D578F; Thu,  6 Dec 2018 13:26:30 -0300 (-03)
Date: Thu, 6 Dec 2018 13:26:30 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: psql display of foreign keys
Message-ID: <20181206162630.mxymdzepmfwhtzgj@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CA+Tgmob5x5Cy+p3fZwbhAOZNHhtTeyPhZjnKiCT8Q=2Q6dqv4A@mail.gmail.com>
User-Agent: NeoMutt/20180716
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2018-Dec-06, Robert Haas wrote:

> On Wed, Dec 5, 2018 at 11:30 AM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> > I added this patch to commitfest in order to get more opinions,
> > particularly on whether to backpatch this.  I might commit sooner than
> > that if others care to comment.
> 
> I don't think this is a bug fix, and therefore I oppose back-patching it.

OK.

That means I can just get pg_partition_root() done first, and try to
write the queries using that instead of WITH RECURSIVE.

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