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 1s4Oj3-003UXS-KA for pgsql-committers@arkaria.postgresql.org; Tue, 07 May 2024 17:35:37 +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 1s4Oiz-004Gwz-J1 for pgsql-committers@arkaria.postgresql.org; Tue, 07 May 2024 17:35:34 +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 1s4Oiz-004GwT-Bi for pgsql-committers@lists.postgresql.org; Tue, 07 May 2024 17:35:34 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4Oix-001uAp-Gi for pgsql-committers@lists.postgresql.org; Tue, 07 May 2024 17:35:32 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s4Oiv-0069u3-OS for pgsql-committers@lists.postgresql.org; Tue, 07 May 2024 17:35:30 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s4Oiu-0022Bx-T4 for pgsql-committers@lists.postgresql.org; Tue, 07 May 2024 17:35:29 +0000 Content-Type: multipart/mixed; boundary="===============7147183210555359744==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Prevent RLS filters on ctid from breaking WHERE CURRENT OF Date: Tue, 07 May 2024 17:35:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7147183210555359744== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UHJldmVudCBSTFMgZmlsdGVycyBvbiBjdGlkIGZyb20gYnJlYWtpbmcgV0hFUkUgQ1VSUkVOVCBP RiA8Y3Vyc29yPi4KClRoZSBleGVjdXRvciBvbmx5IHN1cHBvcnRzIEN1cnJlbnRPZkV4cHIgYXMg dGhlIHNvbGUgdGlkcXVhbCBvZiBhClRpZFNjYW4gcGxhbiBub2RlLiAgdGlkcGF0aC5jIGZhaWxl ZCB0byB0YWtlIGFueSBwYXJ0aWN1bGFyIGNhcmUgYWJvdXQKdGhhdCwgYnV0IHdvdWxkIGp1c3Qg dGFrZSB0aGUgZmlyc3QgY3RpZCBlcXVhbGl0eSBxdWFsIGl0IGNvdWxkIGZpbmQKaW4gdGhlIHRh cmdldCByZWxhdGlvbidzIGJhc2VyZXN0cmljdGluZm8gbGlzdC4gIE9yaWdpbmFsbHkgdGhhdCB3 YXMKZmluZSBiZWNhdXNlIHRoZSBncmFtbWFyIHByZXZlbnRzIGFueSBvdGhlciBXSEVSRSBjb25k aXRpb25zIGZyb20KYmVpbmcgY29tYmluZWQgd2l0aCBDVVJSRU5UIE9GIDxjdXJzb3I+LiAgSG93 ZXZlciwgaWYgdGhlIHJlbGF0aW9uIGhhcwpSTFMgdmlzaWJpbGl0eSBwb2xpY2llcyB0aGVuIHRo b3NlIHdvdWxkIGdldCBpbmNsdWRlZCBpbiB0aGUgbGlzdC4KU2hvdWxkIHN1Y2ggYSBwb2xpY3kg aW5jbHVkZSBhIGNvbmRpdGlvbiBvbiBjdGlkLCB3ZSdkIHR5cGljYWxseSBncmFiCnRoZSB3cm9u ZyBxdWFsIGFuZCBwcm9kdWNlIGEgbWFsZnVuY3Rpb25pbmcgcGxhbi4KClRvIGZpeCwgaW50cm9k dWNlIGEgc2ltcGxpc3RpYyBwcmlvcml0eSBvcmRlcmluZyBzY2hlbWUgZm9yIHdoaWNoIGN0aWQK ZXF1YWxpdHkgcXVhbCB0byBwcmVmZXIuICBSZWFsLXdvcmxkIGNhc2VzIGludm9sdmluZyBtb3Jl IHRoYW4gb25lCnN1Y2ggcXVhbCBhcmUgc28gcmFyZSB0aGF0IGl0IGRvZXNuJ3Qgc2VlbSB3b3J0 aCBnb2luZyB0byBhbnkgZ3JlYXQKdHJvdWJsZSB0byBjaG9vc2Ugb25lIG92ZXIgYW5vdGhlciwg c28gSSBkaWRuJ3Qgd29yayB2ZXJ5IGhhcmQ7IGJ1dAp0aGlzIGNvZGUgY291bGQgYmUgZXh0ZW5k ZWQgaW4gZnV0dXJlIGlmIHNvbWVvbmUgdGhpbmtzIGRpZmZlcmVudGx5LgoKSXQncyBleHRyZW1l bHkgZGlmZmljdWx0IHRvIHRoaW5rIG9mIGEgcmVhc29uYWJsZSB1c2UtY2FzZSBmb3IgYW4gUkxT CnJlc3RyaWN0aW9uIGludm9sdmluZyBjdGlkLCBhbmQgY2VydGFpbmx5IHdlJ3ZlIGhlYXJkIG5v IGZpZWxkIHJlcG9ydHMKb2YgdGhpcyBmYWlsdXJlLiAgU28gdGhpcyBkb2Vzbid0IHNlZW0gd29y dGh5IG9mIGJhY2stcGF0Y2hpbmcsIGJ1dAppbiB0aGUgbmFtZSBvZiBjbGVhbmxpbmVzcyBsZXQn cyBmaXggaXQgZ29pbmcgZm9yd2FyZC4KClBhdGNoIGJ5IG1lLCBwZXIgcmVwb3J0IGZyb20gUm9i ZXJ0IEhhYXMuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzM5MTQ4ODEuMTcxNTAz ODI3MEBzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNjU3MmJkNTViMGE2M2Zl MjM0ZWM0NTRlN2ExM2YzYTM3Mzg2NGU5ZQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K c3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvdGlkcGF0aC5jICAgICAgfCA4OCArKysrKysrKysr KysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcm93c2VjdXJp dHkub3V0IHwgNDEgKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcm93c2VjdXJp dHkuc3FsICAgICAgfCAxOSArKysrKysrCjMgZmlsZXMgY2hhbmdlZCwgMTE4IGluc2VydGlvbnMo KyksIDMwIGRlbGV0aW9ucygtKQoK --===============7147183210555359744==--