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.94.2) (envelope-from ) id 1v29Ic-000mDj-Gm for pgsql-general@arkaria.postgresql.org; Fri, 26 Sep 2025 14:19:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v29Ia-0024mW-A2 for pgsql-general@arkaria.postgresql.org; Fri, 26 Sep 2025 14:19:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v29IZ-0024mN-VN for pgsql-general@lists.postgresql.org; Fri, 26 Sep 2025 14:19:48 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v29IY-000EfV-1o for pgsql-general@postgresql.org; Fri, 26 Sep 2025 14:19:48 +0000 Received: by mail-oi1-x230.google.com with SMTP id 5614622812f47-43d2da52291so1577980b6e.1 for ; Fri, 26 Sep 2025 07:19:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758896385; x=1759501185; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=AFwwPsGKvz8HVeanCBO/kcGeeukqmXe7rVgLR6m4cuk=; b=HPwhFxJxh/Q6rbO59eP4DjL0j516ZxV3WcYX9lqX8rM+sruHVi7nVcmS/PK9Fe5OUU /49W69q7kmYClMWg0RpU8B0XWZwuckMWgP7e/kzEPjbGko8TQxhtT4PfEDnO2JvIkrVV VLUdZAVxr0e798R247kOGWh4UIvsximeDfhseL6iqwFXPJCDaB4RkmM/UvJJZnFIAhdp 12EH7Vd1hb2oRYz3Y2EapaBDRHsWT5cTcaO9pAUUp1ieu2mWdcjcbn2VK5sBZnuXts6N n6V3OYrCQoWcmUdb/KOPCzPZ9bSI1JrYK4cdxoG2RBrH0zPtYTvWJTTSMbdnb81skuax YlsA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758896385; x=1759501185; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=AFwwPsGKvz8HVeanCBO/kcGeeukqmXe7rVgLR6m4cuk=; b=aGRceRP2Y0+oCoWlocOeIZN/XFqxZrYa7vy+8gSbVgTT+hUHFNC/nb4WLXhM2YeYvy yMF1kZUArywO2Ay7+SONEn3lF2cvkKvcNdlLBFgOY1iS4S7bwE5LnP472I+jgqHMiDHS JOniaAnuoEI7fmT5aYDKC/TtDa4M7o/BgYsAnwZUf+YfXvmPiPkeHvAjvNPp221iJmV1 JwFRMXC89TYgqRtkj6HvWJjYfclEIKYLLrrmZRnLARvUmztTL89V6Yv/6Q/i02F5T9Mn YzDdFDPSdDO2JQy7Zdog26vSUd/UbvvSmD40tIVrqEP8UL5kUU+x/7UMB4ND3IDOPUEU 1WaA== X-Forwarded-Encrypted: i=1; AJvYcCXX2iTvJ795A+1gwQ3SHeSxF9rvtIUaVbIhfkrPkwlbjxKxIw0pg6iY/cyDk/g+q1xvo7QYLmlOzKnBCjP2@postgresql.org X-Gm-Message-State: AOJu0Yxz+YyxX/oW1zsWU4PLg0UhScT2mDUYfT0wWlpxQHX5ffv+f28S cgpcu0TGGUGDgBhL+SuBGtQDxQjhOE1EZrMnKj9VYZt14kobFuEBnttOvYIPnC+WyFY+tpBm+72 zUW/vlpoBQUg4ZUxPHmvstKhTCiy2awQ= X-Gm-Gg: ASbGnctAPCBe5eBxKsRpYezkzG1YB0Zw3ywR6akkGK7xONTR79j3dWFynvb2zHwzkkC pEsXvnqy4W7VDWIz5UzjAd6rBg5Lxk8kN18jE4Ve/AuNuu+y1cu+o7keBvcokVvQXT45tBzJF+a VK3u+s6p56Tx1bXBQIGT7gC8n3TPq04iQEaBLI/7jzoIB1qd3Uen/zUYBS72P+sXRSu67V3DLmw zF/wnfhlQ== X-Google-Smtp-Source: AGHT+IFG9s4jaAe8Rb1AaQj8Ntbtzxv4zVrrpC17w7uvVu7RwHLdFL6dWoLAbvjk2QhI6uL4f8lJRNPm8EqR9H+dwzI= X-Received: by 2002:a05:6808:1796:b0:438:3dc7:c2db with SMTP id 5614622812f47-43f503a3882mr3242479b6e.23.1758896384632; Fri, 26 Sep 2025 07:19:44 -0700 (PDT) MIME-Version: 1.0 References: <1124024.1749092239@sss.pgh.pa.us> In-Reply-To: From: Dominique Devienne Date: Fri, 26 Sep 2025 16:19:33 +0200 X-Gm-Features: AS18NWAtgf-bqTFrby5zQEqrIDGJL1--ZbCF_bdvm9mI3WdYjpORFt8d0DiM0LE Message-ID: Subject: Re: Yet more ROLE changes in v18 beta1??? To: Tom Lane Cc: Robert Haas , pgsql-general@postgresql.org 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 Thu, Jul 31, 2025 at 2:34=E2=80=AFPM Dominique Devienne wrote: > On Thu, Jun 5, 2025 at 4:57=E2=80=AFAM Tom Lane wrote= : > > Dominique Devienne writes: > > > Unfortunately, digging into this is not something I can do right away= . > > > v18 is still a few months out, I do hope I can investigate before tha= t. > > > > It'd be good if you could prioritize that a bit more. If there is > > a bug rather than an intentional change here, we'd much rather > > find it and fix it before 18.0 comes out. > > Of course Tom. And as a quick update, we've installed beta2 now, but > still get the same v18-specific failure, compared to v17 and v16 (see > below). I'll be looking at this soon. And will report back. --DD To close out this thread, I'm happy to report that all is well with v18 official. Came a bit as a surprise, given our poor experience with betas and the RC, but magically all tests pass on the official v18. So a GOOD surprise! It's not impossible this is due to recent (unrelated) changes on our end... Good thing I never investigated these v18beta/rc failures, I guess. --DD