Date: Wed, 5 Dec 2018 10:16:33 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	Pg Hackers <pgsql-hackers@lists.postgresql.org>,
	Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Subject: Re: psql display of foreign keys
Message-ID: <20181205011633.GC2407@paquier.xyz>
References: <23923.1543935600@sss.pgh.pa.us>
 <20181204184159.eue3wlchqrkh4vsc@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="7qSK/uQB79J36Y4o"
Content-Disposition: inline
In-Reply-To: <20181204184159.eue3wlchqrkh4vsc@alvherre.pgsql>
Precedence: bulk


--7qSK/uQB79J36Y4o
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Tue, Dec 04, 2018 at 03:41:59PM -0300, Alvaro Herrera wrote:
> I spent a few minutes trying to think of a way of determining which
> query to use at SQL-execution time -- two CTEs, one of which would be
> short-circuited ... but I couldn't figure out how.  I also tried to use
> the new pg_partition_tree() function, but it's useless for this purpose
> because it roots at its argument table, and there doesn't seem to be a
> convenient way to obtain the topmost ancestor.

This has been mentioned on the thread where pg_partition_tree has been
discussed:
https://www.postgresql.org/message-id/6baeb45a-6222-6b88-342d-37fc7d3cf89a%40lab.ntt.co.jp

It got shaved from the final patch for simplicity as we had enough
issues to deal with first.  Adding a pg_partition_root or a new column
in pg_partition_tree makes sense.  My guts are telling me that a
separate function is more instinctive to use.
--
Michael

--7qSK/uQB79J36Y4o
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwHJvEACgkQnvQgOdby
QH32Cg//d/rzJ4u1UDLsgehMES+luFavPBdgvqhZPy9nmush0Z8u99BeLrzmmR6t
qtJLZ5ICEkxZzszqCsLc9VOh8ZRU4tL1OrChkxSSwW5GAW4B4F7ukendg6fu4X35
sNOTPs+DQJoZ5bmi0hvC+McbbpA9/SbRaGGxOycxbVRvECdhxL/NKauDC4YEhub/
SzZ4fZIg+zq+JF6eIN0moBxSe48CI5nTYT1r7DREhMGatwl1NR39BFQmjUCPC7qb
CTdEQry6c5FBcasgAEHSzV33UqJ7I9WI6HsYIp6Gq/hrOLYdHrPQ42+sdwXK9fvk
9TWouGOI1pVp5TKMSuKrKPejM4fWoNLxiTF6OI4BVT8OPwh0+h8Ge5/dHKuVsqze
m5V0RpAAYu0duCRHc/M+iKngIcee86lhDlBlWNi/itHLzGQnnyJTtM/0iLGZLJCl
MBYwbf0FSHpM/dC4fUGc594eST8EXUKzbElejdvEsgc+779w6xBxkra7scxCguBp
QQVT5Ki8Jcs6AWNWBw3ww0mnFrtUEfTHhf90UORKsMzLCEADEmCEcQh1W9DNlMi4
Nanv7oyR9rL16cNMLoOThnhFHSqJ0A3v9vf4GzKv4Vu9OjHWGqkQqcfdukqq162R
y2D8AaNxGvsAsrC8r2fDFzwv0ce7OK10ZCHFDmTZkzC/cTeV6Q4=
=/qIA
-----END PGP SIGNATURE-----

--7qSK/uQB79J36Y4o--