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 ) id 1gV2Zc-0006ml-As for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Dec 2018 22:56:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gV2Za-0008BA-NN for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Dec 2018 22:56:46 +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 ) id 1gV2Za-0008Av-CL for pgsql-hackers@lists.postgresql.org; Thu, 06 Dec 2018 22:56:46 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gV2ZX-0007BM-CH for pgsql-hackers@lists.postgresql.org; Thu, 06 Dec 2018 22:56:44 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 9550E22011; Thu, 6 Dec 2018 17:56:42 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Thu, 06 Dec 2018 17:56:42 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=AOTou/i0PgibLrpS0EceIC51T76 4JgIsdMp0V7yVyls=; b=Rd8QoqF6c75CsBIw5Zr8VqAcHx8xH6IxDfvIqFA5kHp E3wcgbuwAFXqX8RwGnOLNuO+oxjaLp4aFlx4EdJpAPAcNmFljJwjR+67RWCCF67R H9h6ZJ2633hA/L4Z2FWQEdhjgC6hBrYU0sZ+xpMHX1qO6nR9EY1IW3zNYYQX0wCD WZUTINUf0RmEVuqV2HWWYjNHKcpKLAuHhKIEMJfVzywpqOx5raz77OWGFYzG0h0o 7MXUsgVbsIfZPIfFK5tZkPXdL84EMyptn12azeK7opG3zGYSQGlHrvmYcPJERXpD oh7oONJLAimjZBCD1DECct8EZmam3ULjR7WE8/GkAmg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=AOTou/ i0PgibLrpS0EceIC51T764JgIsdMp0V7yVyls=; b=ZNZwuC69wc9samR9XWCSSq +TqmcU6t37KNct3Fnb5WpgE1ksnpN70enwmpZuGmAj+SsZlah8Q3LCxc7Evl6u/+ AeLZ7K0Vcdiemc2sFA6wcgLczlEfAELo093cZkXbNZWnPM6wJ4l5m12T/0pMgvJR kekEUdRSdq0+JXrKM6GcxcJED4putE3jVSv2vO6ouwrH41m0YYrlH/dD2sLdem9F KrAMYIavhC6GGJh6+LOZ2FVoTwiKv/uCm1MNqPoJHwQn6WTmNqUR5zwdnPjuP6Il 59AKaFaqvqVf/f4QT+4jDuzRm4yAqF7IzN30NgpVf51Ti8Em1BUs9VmapEFsTYZg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudefkedgtdehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtd dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cukfhppeeiuddrvdduhedrudefjedrudeivdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id D72D1E44A5; Thu, 6 Dec 2018 17:56:39 -0500 (EST) Date: Fri, 7 Dec 2018 07:56:36 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Robert Haas , Tom Lane , PostgreSQL Hackers Subject: Re: psql display of foreign keys Message-ID: <20181206225636.GL2407@paquier.xyz> References: <20181206162630.mxymdzepmfwhtzgj@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="fNagykWcDoSVAmSd" Content-Disposition: inline In-Reply-To: <20181206162630.mxymdzepmfwhtzgj@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --fNagykWcDoSVAmSd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Dec 06, 2018 at 01:26:30PM -0300, Alvaro Herrera wrote: > That means I can just get pg_partition_root() done first, and try to > write the queries using that instead of WITH RECURSIVE. FWIW, I was just writing a patch about this one, so I was going to spawn a new thread today :) Let's definitely avoid WITH RECURSIVE if we can. -- Michael --fNagykWcDoSVAmSd Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwJqSQACgkQnvQgOdby QH1kyQ/+N6zC5I5EaruKtF/WuJKJTy6pC5qond51nqFken1hTJKP4Lv8P2l36yU1 74E0v7HSvUpF2SVE23qU2OpsmO5RO7WFILvVwYjDkTRnlWPcD1miNjyN2fM77nCM yHb6Av57oJw5xdQsTqOlJPZ9uY9YIR9vhmN9cETZ5gtjWRRyYwUjGb6G8oJezAD+ Ial9gY7DOJlYZVatR2GvJGkaFSnGkphyw1oWaq/+v+5d5iRxiRDg7BnQ9kv8EFjM tLIrDTy6YKhmQ67LXybSmcUgC6jQiY4uy4o8ea44d/2cq6IKMriZiM4qC++kX1Y7 is5uZhtEtZVeLzxHheTbOSaMr0BxtM/AUWsprOSIw+UzLzM3JWJHEsCygh1lpH3n iZLXRifZYgLu4UsUcibxlINh0zFs2u9jew3TO3tAJ5O/cDdoTEpEoFVmy/6BVdda GMNoj8PYYykIOG2q7nbAWrfe3dxP9Gt33QgNZAYMMu2zrfIGXs3Qjt8iBiuOjSLp pDyNS3OO9de40ORvWqCRGOIiToJIZbFoZBzEpqr/iDx+T/udRRwX/V5xTwSeDVWw J43uiuBPI5OOPnubIIxofJ9HhdA4y9m1R2UedIRrRKO8ERYXNoR/JCLez+3Sb8ha xZ67ar1UW2cWI7psz1phIox8XQgA0AIZeZB9izPdAWqjeCaF88A= =XyoT -----END PGP SIGNATURE----- --fNagykWcDoSVAmSd--