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 1uuBV1-004AoZ-OD for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:03:44 +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 1uuBV0-00GnVe-Kn for pgsql-general@arkaria.postgresql.org; Thu, 04 Sep 2025 15:03:43 +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 1uuBV0-00GnVT-9R for pgsql-general@lists.postgresql.org; Thu, 04 Sep 2025 15:03:42 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uuBUw-000YCF-2a for pgsql-general@postgresql.org; Thu, 04 Sep 2025 15:03:42 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-30cce8c3afaso732380fac.1 for ; Thu, 04 Sep 2025 08:03:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756998217; x=1757603017; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=2ncW4n7Zf2XorOTx4ID4BIkTDWM4VmIYOJTtUZOpjdE=; b=Ai53uqKFIh/I4SGSLTjmq/PFlW1QVKE7wFwlRtz6GTBT/SwQNMZ6XEJQsn/OH5SZRx EEsWnFeK5M9NZCNkTxCs761gZI6ztIXH0qoPyQzqMabLNvn11aq+SHPpRTJ+mu2LQrCb WdLnrNqNl9+NXmStMXXzAdLglzvb1VKaG0wdd7fZRZ33e3rCLw+LJB7Xm+eYDNiM08ZM FRmMM3P7jue7vcuORbYKncrkIzmqVYuXEzRq2A/SN3vPjXV3ARRa2dfhfEItBYPLwUHJ /h3rr2X0t4rTmV7irV3ZNudapb/DGH0tkjzJcb13C4JUiz4t1eAe3vvQ/IH5iUsJlqlx 84jw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756998217; x=1757603017; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2ncW4n7Zf2XorOTx4ID4BIkTDWM4VmIYOJTtUZOpjdE=; b=EuaUxB3AHDqTVKjCjsMeQhLEZDaoqaMAQwgAruG7MJBXLbgndaNrhXRGg39066iWtw /ylKrEsx6mnx0c4wXpXlPkvRMyw6wMZZbnACoTcnv6xd6/P6a3Ablxv5tNKGVrnPsK4r /84VbbbWUBj9dN5WFKfUd1Ouak59jpQ0c7J5gftz1V1HGVfyt4yRHCb1Q8ru3Lt3W6zv vX+F3Zr2ewXgB1Jp271vtxyRqhq8Aken7rYJ7947EiTRdmive3bMpEgHUOObuzbQx6MG Qy9Dbccn611mOECwYV6Ip/4BWyaLKjbHgb5xlFoo2rYCMZ040JdSUim5Oa8VHKMnrANy C0Xw== X-Gm-Message-State: AOJu0YxtJa/6G7OkPHNB1fPZONzvQa2v3eTOFFYT8ht2wEpqPJyIlHuO C5zFmuWJliY4Jfsw9VfOCeuXpCYzChYzjnZBlZZFv/Y7maIXVaibFRmw/gBdJi51oso3R8cB2L8 pcRuGJMWZTLhWK9QxfgJniASQpIOSXzljln/N X-Gm-Gg: ASbGncv7xrX5W9aM/et/HvdmWj7B1E/ry2ytGHt5xIXENSoEhBRGMprxHD2x1GJYfJ9 pHozlg13xqLRtIo/eYa+cY7j1brPv5D3yMqp3EHcezR/qGBFz9wEQ9FyX1+TAG5/tAECmwARBar PVe8FOgjrAPmn+D5rvJOhxCbWVQ/oUr2PI7b5WQzPpA8mOysQP8a6OLRjAn7nk2U2uEjwfNCxdc OWfNDd49t7uxeemoNng0Z4Jn9UHIFc= X-Google-Smtp-Source: AGHT+IHVk+bIE+AZx2nUb4T4Sm/KUsSTZS4iX8BlD9PHptLViEiVbrzB4JBBUVVQfMC+2kfcQEmMDXa1/+wEtexwJwU= X-Received: by 2002:a05:6871:7288:b0:2ff:9604:b95a with SMTP id 586e51a60fabf-3196306a2c9mr9849424fac.3.1756998216814; Thu, 04 Sep 2025 08:03:36 -0700 (PDT) MIME-Version: 1.0 From: Dominique Devienne Date: Thu, 4 Sep 2025 17:03:25 +0200 X-Gm-Features: Ac12FXwSvurm5KKPMvtSSnLIpzWQWxJJeHC_pa1BBiBE7_RaKiXnK06gYb_M44U Message-ID: Subject: Latest patches break one of our unit-test, related to RLS To: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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) 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 in these patches could be affecting those areas? Thanks, --DD