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 1w3Zwg-001MVz-2B for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 13:31:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3Zwe-006CP4-0W for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 13:31:20 +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 1w3Zwd-006COv-2s for pgsql-hackers@lists.postgresql.org; Fri, 20 Mar 2026 13:31:20 +0000 Received: from mail-oi1-x22f.google.com ([2607:f8b0:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w3Zwc-00000000Aj3-1Ny3 for pgsql-hackers@lists.postgresql.org; Fri, 20 Mar 2026 13:31:19 +0000 Received: by mail-oi1-x22f.google.com with SMTP id 5614622812f47-464bba3a9easo1101516b6e.0 for ; Fri, 20 Mar 2026 06:31:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1774013476; x=1774618276; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=AGwuJwoP8Fueq8bAMhhM0mvVM5DwskamZY5hHLfpO5E=; b=0ldJjs4rT35L5oHqOtL5prqr+2l5OLnRdHUZO3dzbJF4PkadGy/icKsvDHSYH58fY0 yP0AlAPk/NH7hFBEotjwjvPkY0VZA25O9GlUvrAZD3QK+oy1z6bJzp5xrpIHFnOHSpIn OdNhCTTj6sKfZjorE1+prYz4h1Zr6XNU1yABd6QHynjzmcGzbcf9JFKXPhVsk8YEXv1f a6KFuwV4XcncslV9BuC+R3oGwel/X1HZvXuv44j8ypfyPiF2EMDSSwDnC9f399De2e9J XUp8uCK90x0b0tXJNr3MzHIL+6AaTfiNRchH6ggehEuCJ8pSxT+uhB4qgB3DNcfi4S84 wH7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774013476; x=1774618276; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=AGwuJwoP8Fueq8bAMhhM0mvVM5DwskamZY5hHLfpO5E=; b=qqhXDPgBp8bmkC8ZpcPKPXXsx4Dn4MOrNcPYDOjQbJ9WFdN03ESXYmeyUT14s+/oSH DbF/PA+nKGx4KLALuUKtpKT2qRMBGlnTLtG5CEtSmJUHi5Ro+TTfN7Fzihsn19ir6EtD iiVy9G7/2soHhpa+zHdasQE9YeC46G67MEslzQFiqkuOzyruqgxuMTabseOswbbjx2+p rAgxocUNECotEB+/Xv2JOFUA5B47oWKNOdTBB48uJPSoEUchhsmbcEY/3IuN4Nw4A3tm 6J7X8BAXLA1cq3HkNumApk4GrjhXuIZJc6t3N52EMMhhoeX1MOKKH86lI9ibhbIqlRAk r1RQ== X-Gm-Message-State: AOJu0Yz9+fUKYovVGUpt4MqIgx3AvVW2UuOkPDR+vwT2V8zib6udkf5w GyaYwPJPhdztP3C8LY4aP0gR74a5QM2VoeOseQdM/K/h5VduGXhLWuoQyr4RYvpDiks= X-Gm-Gg: ATEYQzxD+nn/wU1sHhaA88EOkFhGKB16Jn2B+i+8VagH8Rpzau94wTBXN4W57ukAaTg afwtwB3MbP69YvnkOau6YWHfIvsPr3uBws22Ac7smmgQNgDk18rq1ZynWkhtdPxPnM6HhJ3I16m 9CB1kzKjO9BipxBZFNzpzyyQXOSaxreiAc77PplPvxQMZPnW7FqJXxI3s7w2F/Abu0nKGThnYy0 HbnRCXFwA1r6/eP0e0sbndAMkZec2MmkG3k13VR/HOhtvzLM+UdZj02vysMpZsOGz4VWQYLDr8A Lw6tmwD7IFl7IPj1KQNr+oL1FkZFnLXiCiI1kirYQ0+cNiqqcXd5w2TT1xjMEpMMvpsvVN19Oe3 1zwgzhfmb5ISkVTFc16Qa/V8KAwZa3daaD2eZOMorhSvEA71UVP4gfR/Z54mCEjjOQrWvV/na4H Se2Py63w3HL37Dv6ZYXEVb/wxQLocThSQYiGMd1kJT X-Received: by 2002:a05:6808:c16c:b0:466:fd60:239b with SMTP id 5614622812f47-467e5fa8850mr1404361b6e.43.1774013476139; Fri, 20 Mar 2026 06:31:16 -0700 (PDT) Received: from ?IPV6:2605:a601:a6b0:500::1cb? ([2605:a601:a6b0:500::1cb]) by smtp.googlemail.com with ESMTPSA id d75a77b69052e-50b36cb2e29sm22904071cf.1.2026.03.20.06.31.15 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Mar 2026 06:31:15 -0700 (PDT) Message-ID: Date: Fri, 20 Mar 2026 09:31:11 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_get__*_ddl consolidation To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: PostgreSQL Hackers References: <202603201311.yhtqmvektawm@alvherre.pgsql> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/ qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm VRu7cmw= In-Reply-To: <202603201311.yhtqmvektawm@alvherre.pgsql> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-03-20 Fr 9:15 AM, Álvaro Herrera wrote: > On 2026-Mar-19, Andrew Dunstan wrote: > >> Greetings >> >> Euler Taveira and I have been working on consolidating these patches. > Hmm, did you remove the permissions checking to dump objects? I thought > we had concluded that these were needed -- ie. you have to have at least > CONNECT to a database to be able to dump it, and so on. This way, the > functions do not override a DBAs intention to hide the information, when > they run REVOKE on the catalogs. I know this is a nonstandard thing to > do, but some people do it nonetheless. > > https://postgr.es/m/202511131446.uzn4c25ljmd4@alvherre.pgsql > Oh, hmm, yes, I think we did. Will work on it. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com