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 1uuBe2-004Drp-HO for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:13:03 +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 1uuBe1-00GwBv-KL for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:13:02 +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.94.2) (envelope-from ) id 1uuBe0-00GwBe-SS for pgsql-general@lists.postgresql.org; Thu, 04 Sep 2025 15:13:01 +0000 Received: from fout-b6-smtp.messagingengine.com ([202.12.124.149]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uuBdy-000Wed-37 for pgsql-general@postgresql.org; Thu, 04 Sep 2025 15:12:59 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfout.stl.internal (Postfix) with ESMTP id 14B841D000FD; Thu, 4 Sep 2025 11:12:58 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Thu, 04 Sep 2025 11:12:58 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= 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=fm3; t=1756998777; x=1757085177; bh=GJQr+Mt+tpsF3wTUjhgx3xivDgMeWnkTqoNBufVo7eU=; b= VoIswkVRgiYBU9qMpgOX/X4P5lcKD885GD5QFX4bhvOfxx4dao9kiBVgQK+SCw+A HRNxSbyW+OipDZflCUBHQfQZd1Fp8oCZgUhXwtQNmtEf66+rwZyQJwg6XcnkZ+uZ dAahQ5/qUlhyFE1mZDRspTaSn+hUI1S1P3BjdQ+cUovSXZObwOftWPX7t/xvWRFZ 2ZddWgmdmrk0SrnkkOM1si0O8Ld521PrwxEBNx5NtqlH/MFiNL3hKkm8HJYaQVXF Q9s0l21OOdRlYpCnlNJHhJUftXUiDRRnQJnsCWTbPQoUGfjUGK9PCQIttpoGbo+G PcIL12XKR6MbgaGVVrmc3w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=1756998777; x=1757085177; bh=G JQr+Mt+tpsF3wTUjhgx3xivDgMeWnkTqoNBufVo7eU=; b=PU4JgsrNtahvYU9No Y0JRKbq+6h5bjShfrnDL9m/oV5em4dHUTgkH9Oo6XO4s9yXRUP9GFhgpO5BgtHtp qcLxCLa/0d+lfAg5/X9bRHtu05LXRbHvG8tcKaxf8nNhgSoR9QSWS0Cls/MzI7uR apvwPpRQr5xMQCN+O3bMGoErizxsQt9GRDmVhsJ3noCodkM4DMx2SMUuyJov9mi5 BFORQWmQqbsnShsGn2IckAnCbQk3J0npEOq1JgtwtdRJsEQ0w+3Le56fWUWmMVKa FN57bLkAeAVutwMh3unT1fiAvrzOX9bcngZfjw12FysjNjKNI0aQqS2vX6Mg6+Eq KnAtw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdeifeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceurghi lhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurh epkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghnucfm lhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenuc ggtffrrghtthgvrhhnpeeivdfhieehheegueeileejieettdejhedugeefleekvdelkeeh tdfgiefffeekudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfh hrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgt phhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopeguuggvvhhivghnnh gvsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesphho shhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 4 Sep 2025 11:12:57 -0400 (EDT) Message-ID: <7132f28c-1437-4723-a363-c19b99a33bec@aklaver.com> Date: Thu, 4 Sep 2025 08:12:56 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Latest patches break one of our unit-test, related to RLS To: Dominique Devienne , pgsql-general@postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/4/25 08:03, Dominique Devienne wrote: > In the same vein as v18betas breaking our unit-tests... > (we still don't understand, haven't looked much though). > > OK, above it's about a major upgrade. So that's one thing. > > But now, we've ascertain that a particular test is: > > OK with 16.9 and 17.5 (we cannot test on beta2 anymore) > KO with 16.10 and 17.6 (and beta3 too, released at the same time) How did you move from one version to the other? > > Which for a minor patch is a surprise to us, not in a good way. > > So... Did anything change around RLS in this patch series? > Anything changed around ROLE INHERIT rules? > > The symptom is that a LOGIN user lacks ROLEs is used to have. > So perhaps some GRANTs are now silently doing nothing, > for some unknown reasons. What are the GRANTs that are done to give the user the privileges? > > What in these patches could be affecting those areas? > > Thanks, --DD > > -- Adrian Klaver adrian.klaver@aklaver.com