Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5lay-0000cV-Mj for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jan 2022 09:31:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5law-0001Kl-EE for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jan 2022 09:31:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5law-0001Kc-4e for pgsql-hackers@lists.postgresql.org; Fri, 07 Jan 2022 09:31:34 +0000 Received: from dish-sg.nttdocomo.co.jp ([202.19.227.74]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5lar-00051O-Nj for pgsql-hackers@lists.postgresql.org; Fri, 07 Jan 2022 09:31:32 +0000 X-dD-Source: Outbound Received: from zssg-mailmd104.ddreams.local (zssg-mailmd900.ddreams.local [10.160.172.63]) by zssg-mailou103.ddreams.local (Postfix) with ESMTP id 988A81200DD; Fri, 7 Jan 2022 18:31:24 +0900 (JST) Received: from t113sg-mailcc111.ddreams.local (t113sg-mailcc111.ddreams.local [100.66.13.221]) by zssg-mailmd104.ddreams.local (dDREAMS) with ESMTP id <0R5C00J8C2GCNLE0@dDREAMS>; Fri, 07 Jan 2022 18:31:24 +0900 (JST) Received: from t113sg-mailcc112.ddreams.local (localhost [127.0.0.1]) by t113sg-mailcc111.ddreams.local (unknown) with SMTP id 2079VOhM032093; Fri, 7 Jan 2022 18:31:24 +0900 Received: from zssg-mailmf103.ddreams.local (unknown [127.0.0.1]) by zssg-mailmf103.ddreams.local (Postfix) with ESMTP id 2ABEF7E6036; Fri, 7 Jan 2022 18:30:34 +0900 (JST) Received: from zssg-mailmf103.ddreams.local (unknown [127.0.0.1]) by IMSVA (Postfix) with ESMTP id 287448E606B; Fri, 7 Jan 2022 18:30:34 +0900 (JST) Received: from localhost (unknown [127.0.0.1]) by IMSVA (Postfix) with SMTP id 267208E6065; Fri, 7 Jan 2022 18:30:34 +0900 (JST) X-IMSS-HAND-OFF-DIRECTIVE: localhost:10026 Received: from zssg-mailmf103.ddreams.local (unknown [127.0.0.1]) by IMSVA (Postfix) with ESMTP id 568F98E606E; Fri, 7 Jan 2022 18:30:33 +0900 (JST) Received: from zssg-mailua104.ddreams.local (unknown [10.160.172.62]) by zssg-mailmf103.ddreams.local (Postfix) with ESMTP; Fri, 7 Jan 2022 18:30:33 +0900 (JST) Received: from [10.132.150.170] (unknown [10.160.179.1]) by zssg-mailua104.ddreams.local (dDREAMS) with ESMTPA id <0R5C00TW62EUGG00@dDREAMS>; Fri, 07 Jan 2022 18:30:30 +0900 (JST) Subject: Re: \dP and \dX use ::regclass without "pg_catalog." References: <20220107022235.GA14051@telsasoft.com> From: Tatsuro Yamada Message-id: <1b7d4248-a96d-6e5c-bde9-d7d5584e7448@nttcom.co.jp> Date: Fri, 07 Jan 2022 18:30:30 +0900 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-version: 1.0 In-reply-to: <20220107022235.GA14051@telsasoft.com> Content-type: text/plain; charset=utf-8; format=flowed Content-language: en-US Content-transfer-encoding: 7bit X-TM-AS-GCONF: 00 To: Justin Pryzby , =?UTF-8?Q?=c3=81lvaro_Herrera?= , Magnus Hagander Cc: pgsql-hackers@lists.postgresql.org, Tomas Vondra , PostgreSQL-development , Alvaro Herrera X-CC-Mail-RelayStamp: CC/Mail Relayed List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Justin, On 2022/01/07 11:22, Justin Pryzby wrote: > But, we missed two casts to ::text which don't use pg_catalog. > Evidently the cast is to allow stable sorting. Ah, you are right. We should prefix them with pg_catalog as well. Are you planning to make a patch? If not, I'll make a patch later since that's where \dX is. Regards, Tatsuro Yamada