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 1uuBjR-004Fpk-IR for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:18:38 +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 1uuBjQ-00H3nS-NK for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:18:37 +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 1uuBjQ-00H3nD-C8 for pgsql-general@lists.postgresql.org; Thu, 04 Sep 2025 15:18:36 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uuBjN-000YJu-04 for pgsql-general@postgresql.org; Thu, 04 Sep 2025 15:18:35 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-b043a33b060so186877066b.1 for ; Thu, 04 Sep 2025 08:18:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1756999113; x=1757603913; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=2OPDzmJdh/g828JAnnW/E4WUznjHKXK2KdWImzJgxuY=; b=RKWCStVW8BYrfGvCBnbh149DlF5vR5oTtFUhtk4/Ef3B2x4wXjNsQCdQ4q10yD4LIZ p9ogssXLAPgB2Q3x4RpGeP7py68DaMlU8hKct2NtmZKUsuOjtXC2+LoeY4mQVCDyz7cM 1CCE2nVj3ckwB9IF430yYTD0nOBAYkTdu6vfnWxX73y7MjdnURutA5owLem4vIQ7/YRR RbqCZ1M/8p09BZuQraZj0rw+i6l1XmGJ2mjj+7lu3UBZWejfSVRJwCEKezBrfwgqIrXP uYFuyubenEjRh4NTPBg+w+3Vtd3741UB8oKxUmltVH+ek4XUHtZjOkF2Hq4xY/vlb5n5 PD8Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756999113; x=1757603913; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=2OPDzmJdh/g828JAnnW/E4WUznjHKXK2KdWImzJgxuY=; b=rDXUayVIhPZZxXMjwunX2O0W8WliLeRBUYB1gP+76lPIn6GANmQ+/dC2A9de40VqYG Ecfy9Ebsl8OJyiS4b7czbML2jGhPck24zr1MU6Evo68NX0Erc6nW9N0902WPoIIMX1xW N84bhcoKIVOOZskDfNQoW1JbE6y/kldgnERWpAQomlHat/u3BVLgRIG1XU+ni/Ts5Ch3 L6K32rXBZa/t9M679NNSr7sb0b2Qerzo700TQqttHndoVZQXo2UVC9+yAyftrm66CY5H GLmzM/TTe8WfQrpcZd2TqP8mrW3qY0Z5tl1mhRxPEocAAlAJWinpObaD9OkKMnZJeWyg SCAg== X-Forwarded-Encrypted: i=1; AJvYcCWMgeFseptEEC6HvUL2ahj5DDPah/Qqt9W5n/uQ2NEpfkoUX29fsisdrGdFvJV6vY+215ZY9UbYBcdcBOG7@postgresql.org X-Gm-Message-State: AOJu0Yxyjz7WCp4PeP1bZxRklC4GP/Ck3EiHb77zyl2dCo/fdWumhKgI +GHPb+CQ5fwxn5zBM+aEeRThRsKVtIX6ZiAOtvYCkv/jnTOLTuwVgGU2o9Mv8Go6fGqGuqm3Ni1 OKoxv X-Gm-Gg: ASbGncsxOyAIXEnyZxLBxE7mdxDxwp799K22wyvNTL/5ZceinXJ94H4JETyyU3r88BB QNGmVeuGi5mruKO4vfqJWrqrrUWcL2ZWGHOlJIYpfH8Vi5pLCp+8HMtvmny927I0JH4IGGWrcXV bmr6ZkfBuTKv0LgEVgVrQCgzxmj8niD6HTW3VuvqpS8WmQCOIOA+hiXxXlbcSxeN1qHKvd4nQv0 fVoOfU9Hv3HyalpHakvNAWaNKx/CHpvh55ib1yiNququjsyQjZHwwmVvmNc0mVx1/BxDgOzQPI+ 8Ni9WwjI3ykNutY/mn8Y8kdhMsd3UswQalzjg3tJd69E8e6iZQETf/f/YKbCyMqoHNp8lwC6X+Z bZz+W8DQep39m1waYJMyUa60DjLrMaNXwz7vSlbUsLTIr/wUjgfVVphMZueA= X-Google-Smtp-Source: AGHT+IETIcP2yEsPo/tf8UTjqWyRNfqhXj657lBmn7WrGWHciClZ/wI9PIbjk7rDlusXD4kSz/koNQ== X-Received: by 2002:a17:907:7202:b0:b04:4625:2372 with SMTP id a640c23a62f3a-b0446252767mr1156526866b.15.1756999112961; Thu, 04 Sep 2025 08:18:32 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([41.66.96.30]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b046b783722sm402330766b.97.2025.09.04.08.18.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 04 Sep 2025 08:18:32 -0700 (PDT) Message-ID: Subject: Re: Latest patches break one of our unit-test, related to RLS From: Laurenz Albe To: Dominique Devienne , pgsql-general@postgresql.org Date: Thu, 04 Sep 2025 17:18:31 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-09-04 at 17:03 +0200, Dominique Devienne wrote: > 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) >=20 > Which for a minor patch is a surprise to us, not in a good way. >=20 > So... Did anything change around RLS in this patch series? > Anything changed around ROLE INHERIT rules? >=20 > 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. >=20 > What in these patches could be affecting those areas? Without a reproducer, that is a wild goose chase. Yours, Laurenz Albe