From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: psql display of foreign keys
Date: Wed, 2 Jan 2019 21:38:40 +0100
Message-ID: <34258172-638e-38b7-7ef0-2c1e0e510b87@2ndquadrant.com> (raw)
In-Reply-To: <20181206225636.GL2407@paquier.xyz>
References: <CA+Tgmob5x5Cy+p3fZwbhAOZNHhtTeyPhZjnKiCT8Q=2Q6dqv4A@mail.gmail.com>
<20181206162630.mxymdzepmfwhtzgj@alvherre.pgsql>
<20181206225636.GL2407@paquier.xyz>
On 06/12/2018 23:56, Michael Paquier wrote:
> 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.
I'm setting this to "Waiting on Author", awaiting a new version based on
pg_partition_root() once that one is done.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, michael@paquier.xyz, alvherre@2ndquadrant.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org
Subject: Re: psql display of foreign keys
In-Reply-To: <34258172-638e-38b7-7ef0-2c1e0e510b87@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox