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 1uxYss-00FeuA-3v for pgsql-general@arkaria.postgresql.org; Sat, 13 Sep 2025 22:38:18 +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 1uxYso-006fbZ-Om for pgsql-general@arkaria.postgresql.org; Sat, 13 Sep 2025 22:38:15 +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 1uxYso-006fbR-D9 for pgsql-general@lists.postgresql.org; Sat, 13 Sep 2025 22:38:15 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uxYsm-000G5E-2Z for pgsql-general@postgresql.org; Sat, 13 Sep 2025 22:38:13 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-45f29d2357aso2435615e9.2 for ; Sat, 13 Sep 2025 15:38:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1757803091; x=1758407891; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=vNlQdt14NYZO2fvtp8qE4lzHG8xVWDjQIn/8HigAFgY=; b=coXR3nC6xdjN2SHMBESTmw1QknaJIOMp8oKa340bSD/6gSbyTp7fw7+R4b/vD/iXcc hqormI4x3zSs7o5RuVzU3InZdbsZtjaQZbD5KZYMyISrPD/WGOuNaNHb6HaoNd8uhbsh dRRUjn9eNRSFaaprLcwbqfmyTIjhs0DO7UNWNvVt6iY/m4VTGBeOh/goSZhmmiC2bhxi J5V3xzlQn7lEtgmsI0ZUiqcaEETXyxto17nlC5UIn16uWPKEW/w96PSFaWKQD6Ho2kMK Y804kqQMR9xEgW5byctyrVToHpHMgl5XOCUhFT6eIQNXUsTd6CL8+SItDlG1WOHpuPTD mfug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757803091; x=1758407891; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=vNlQdt14NYZO2fvtp8qE4lzHG8xVWDjQIn/8HigAFgY=; b=Bf41pTHR2Cfbtt8SDvVMAdKxKsuQv17DD/HXP7saCMw1lz166W954whcqRWXqDG33C waQaLw5kLCF3I/jIe69aEeOms0O1S/SAEDtmHIKBRLcBg+Qw/XWvjFzPOVh+L0pzuZiC w/s2wEYWenB9iXZtK6K9aIvYyPsnSLtHZ7xoMV49zXiwFnICAFpVthNj8+kSKuCr2HQc IhJLYKt6EEnFdRH6XSkAA7i7jbtp/yeKAz7qmG94FGo/4pFlHH6sye2oW+qQ/tUN7y3a ONg5yfLVvf8ctbhmZgMC8l/qV9UZpRjewCUCvumrf/VLOLfNDF4ndZuo9oCxpkQ7cHBk p57g== X-Forwarded-Encrypted: i=1; AJvYcCVp+ln6L3AJ/A0lBkZolZl89w65Mrdk9FYDudpDpkI+EsKQwCkB0cjH5f//THHFgpFQFZR9IPHiQh3a+X77@postgresql.org X-Gm-Message-State: AOJu0YzE7JskA8oLyK6jvQSsPNFgtLqxsUvq344kVz8dWQKHGp01hkFa /dG4yHePu/YffAH1ugsXyXQ9BLCQ5Gr4/XBWcgWZXF1lJttxek+5y/aJbDvZAZQ6ma4= X-Gm-Gg: ASbGncvC6x5Ab+al3VyEqqkj3fGCueqnH6XngwGxqyfAJ8fHxvk3Eryt1Bv4RgYnLCC LtBIxHdg2/FaDtH0zsa/fWnHe5+RxVajNpJJMzKo3nD2r9ewIe6Sgtt01MKnXvRcEmZ5ZVjSgI8 CzRTdBdMq1v0h3lFUL5s+VLEzyDK8R/nHziHHKcJUdjiDPjEf4iieLbpTonav4mZFiywbtsAxeW n37rUY1ekkXqFQelYi94yRdeu7RcLmehPa+TlBDtO8HTEC3G9fA2ieQw2K4I7qVy9/3lOJvSXz4 aPzulX3ej8C8nTXZB8ZP9/HuOSt3fMhRSeJR2bZskVARKe9SEDrXQ46CKBbsml6YPpU8e5vYJsb GGanjlOAIhJItN6eWTdrISK6fIPggkN5tRMAnepOMPn2G8Htlb84TukfHaqNZ4Lg= X-Google-Smtp-Source: AGHT+IFDAxpUXrKkueENH9GIURbzMzghtY3Tj6wG6yX5CyN/8sv5TW4qCvcLn6bwOqXKA2y8ohNSLA== X-Received: by 2002:a05:600c:3b93:b0:45c:b5bb:7b51 with SMTP id 5b1f17b1804b1-45f25f69b81mr39586605e9.30.1757803091400; Sat, 13 Sep 2025 15:38:11 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:255:30a:2403:9037:2d08:c2c]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3e9cf04db65sm426004f8f.3.2025.09.13.15.38.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 13 Sep 2025 15:38:11 -0700 (PDT) Message-ID: Subject: Re: Latest patches break one of our unit-test, related to RLS From: Laurenz Albe To: Tom Lane Cc: Dominique Devienne , pgsql-general@postgresql.org Date: Sun, 14 Sep 2025 00:38:10 +0200 In-Reply-To: <296006.1757797220@sss.pgh.pa.us> References: <77a63548783dd4007ee479a4c5ed300629aaa776.camel@cybertec.at> <2109533.1757686026@sss.pgh.pa.us> <2c58dcdba889f5b28df5ad9d21b5ea2d0ac63a9a.camel@cybertec.at> <2673230.1757722323@sss.pgh.pa.us> <501ee89ad54184804d14b416781dafd340c789d3.camel@cybertec.at> <2683918.1757728397@sss.pgh.pa.us> <296006.1757797220@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 2025-09-13 at 17:00 -0400, Tom Lane wrote: > Laurenz Albe writes: > > I came up with the attached patch set. >=20 > I did some more work on the comments, adjusted a couple of places that > could be simplified, and pushed it. Thank you! > > I used two separate patches for clarity and ease of review, but both > > should get backpatched. >=20 > I didn't really love the "fix it and then explain it afterward" > approach.=C2=A0 It's hard to review a patch if you don't understand the > logic.=C2=A0 I considered swapping the order of the two patches, but > eventually just merged them into one. Yes, having the refactoring patch first might have been better. Yours, Laurenz Albe