Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wXENu-0038kf-0i for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jun 2026 08:34:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wXENt-00A7MX-0G for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jun 2026 08:34:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wXENs-00A7JM-1j for pgsql-hackers@lists.postgresql.org; Wed, 10 Jun 2026 08:34:00 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wXENq-00000001yo1-2Ygn for pgsql-hackers@lists.postgresql.org; Wed, 10 Jun 2026 08:33:59 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.stl.internal (Postfix) with ESMTP id 743427A0084; Wed, 10 Jun 2026 04:33:56 -0400 (EDT) Received: from phl-imap-07 ([10.202.2.97]) by phl-compute-04.internal (MEProxy); Wed, 10 Jun 2026 04:33:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1781080435; x=1781166835; bh=U/sIlfAOmkvIJx2oysCKsnBccP1lYCrXx63qMUuvkgk=; b= mW0aFbOZIMX5CUkjARApZ8xbrH2ZL5m0Tv7li7c50KeNZ+8TziRmx2Bqq5q3r6S6 p2t7ZbJOUTQ1HPKKcYmB6YEoZkpxgx6WWU/cakNA8Fq09xzCB7XecnaRTn3WXwyX 71+NCVbqhxJuMAGIhV+9oOQUoTf88bt3ceig64mnGSiP8yDePuPEb3VzM9O8chZe msYCC5E4PHDbh93X7PRm12eegLssIIctIhCYiQvFqUXDM6UH9pHWs977kCfpnNrC ucZC/RYd6WQc28EmvjFbh2g0lWigwwN6RPd5NQQ7DYfnDUZJbKKJp63IIujDIuls GdQbL90i8mc6bFk4eyI9Jg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1781080435; x= 1781166835; bh=U/sIlfAOmkvIJx2oysCKsnBccP1lYCrXx63qMUuvkgk=; b=C tfdqiFVjF2XS0EmttCfAsTVeOodBu2ak2Ox49oc0MKwga5AL833hshPEhnd6+3aG 1LGxqis+Wtswuc7waWBmcBOMrCDY+bTiAyRe+j6OQBXqbNt2Dji0iL+xFS+VG/t1 xeeR8B/o4vDwPL90DNHzUon0hFm1ER7xd9J7GrLy0ahSMylInVkdR767W3m7UElk HS6H4Xb5j0Fel+hmvNkkv9/5qHyw35JE0IDIlmYTBwQ5wDBbA6oaSBksjXO0Drlx Qt+3mMRguisGE/d2yW7R9RaHEc3tWs4cmlTjcrzS217+wZbo/42T5kRHhhUFGa2u sauUCK1KBZ9kk1HgGwAsg== X-ME-Sender: X-ME-Proxy-Cause: dmFkZTGwT5TbyFNLZvOqzW8FERUZH4TCDlcTCQmW5FTOZNDOB++FgeNNknX0+s9nq9HQYa o25pyFdZXco2ohGx+zCHwjc/IrV5F+TbVdoxW54wCY6AZI0kC5RWpI0M09qwdkPr3bDR7X 0/fJxC73SBNkF3+Rn7xQIJ6QJNcOEWj7mU1hyF//3virAjLfkWJ/Y8Ht82dugenzfIShSL j4XgziDSWSoQzUc4L9GfCVHfPj2Z+KwOiIGl7/XsLqzrVDltvI60hwBZCQZNM/7zajj+OJ nSKawppjIHfQRhJ1/PbdtjAE7Gp9xQTajGQozGTN8WetMpNcmuzVAg54qeLygJZ/2rtpX7 V4JxiTJBVbQI/5YklbW14w+qZRI5nizBETKhInSlkY6eKCLrvW1C3iRHuH+HR6FphSo9qi wGPLLEJMXr9YlrFd5JtK9jsL3yVAllCyaV1zBSQ1Z9HmBCYQ5Mjj69IGAxuW0gOJHewql1 xSoXo59d2veplgI1hE7D7TySL3Jfh33u4H2PeAv97Qjo0SqtfkTnngGOPkon8UaYLxoBM+ AvDA8RvBEiTZIHSx8wISDH86pHhkB5UWg+9ANB7wxT7YhxaIFtCvzDgIWPzdp/ngKS64sP 80yH95YfiSZEvtsUn54/kl+WFdkuZj4iC43BuLnkc0k7v6UFVl6zzM209llw X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id AE9EE1EA006B; Wed, 10 Jun 2026 04:33:55 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 Date: Wed, 10 Jun 2026 10:33:35 +0200 From: =?UTF-8?Q?=C3=81lvaro_Herrera?= To: "Bertrand Drouvot" , "Tom Lane" Cc: "Michael Paquier" , "Chao Li" , "L. pgsql-hackers" , "Fujii Masao" , "Peter Eisentraut" , "Jeff Davis" , "Ashutosh Bapat" , "Amit Kapila" Message-Id: In-Reply-To: References: <1236173.1781057568@sss.pgh.pa.us> Subject: Re: Fix unqualified catalog references in psql describe queries Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-06-10, Bertrand Drouvot wrote: > I do agree that doing so would "destroy" the readability. I did not=20 > look in detail, > but what about forcing ALWAYS_SECURE_SEARCH_PATH_SQL before the querie= s=20 > and > restore the search_path once the query is done? (that way that would=20 > not impact > the readability) I think we should just ditch the idea that operators live in schemas. --=20 =C3=81lvaro Herrera