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 1taGXQ-000GfR-TN for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jan 2025 15:51: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 1taGXP-000iWx-KU for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jan 2025 15:51:35 +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 1taGDe-000PeI-FG for pgsql-bugs@lists.postgresql.org; Tue, 21 Jan 2025 15:31:10 +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.96) (envelope-from ) id 1taGDZ-000kfh-0K for pgsql-bugs@lists.postgresql.org; Tue, 21 Jan 2025 15:31:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=L/wq7Rb2RffUI4KZoZ2mAH66MageBrw9LZXV+1zsbzU=; b=icAp2fDamncKi6tO3j4YaUjcpw Pzqo9zFa2X7xTcxiB10J5gz0gqOt4nYOZrjKj79c1mMi1VtZsurO7Jm7e/yT9uUAjAMAAnUcfVEU4 +5rgkGFU1TOKs0jovJVt1Ljj/nkfHwH1Bsu4osGP+Hl4bvQ3MGCd31V6xdXLuYGSYXc1wcXVQeXM9 CtJwCW/aAb7Jev5vpbG0Xi7zn8t0oIl7adQajFPJ9wO3qnnwiTCJXTlOccuuTGP9sv9hLUyL7sWI+ zVMfPHn0pbvCXQwgpurjRnmEbbmBZZteeLB1I908oWV0d4M9DEv+49c35u8pvw/l4pje5oux2Pkeo bEvZgvEw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1taGDY-008Oxl-NO for pgsql-bugs@lists.postgresql.org; Tue, 21 Jan 2025 15:31:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1taGDX-0021f3-96 for pgsql-bugs@lists.postgresql.org; Tue, 21 Jan 2025 15:31:03 +0000 Content-Type: multipart/mixed; boundary="===============0227115055022207516==" MIME-Version: 1.0 Subject: BUG #18782: Inconsistent behaviour with triggers and row level security - depends on prior number of inserts To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: julian.wreford@gearset.com Reply-To: julian.wreford@gearset.com, pgsql-bugs@lists.postgresql.org Date: Tue, 21 Jan 2025 15:30:46 +0000 Message-ID: <18782-c189e15f237f27d6@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0227115055022207516== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODc4MgpMb2dnZWQgYnk6ICAgICAgICAgIEp1bGlhbiBXcmVmb3JkCkVt YWlsIGFkZHJlc3M6ICAgICAganVsaWFuLndyZWZvcmRAZ2VhcnNldC5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxNy4yCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMSBQcm8sIDI0SDIsIDI2 MTAwLjI2MDUKRGVzY3JpcHRpb246ICAgICAgICAKCldlIGhhdmUgYmVlbiBzZWVpbmcgYmVoYXZp b3VyIG9mIHRoZSBpbnRlcmFjdGlvbiBiZXR3ZWVuIHRyaWdnZXJzIGFuZCByb3cKbGV2ZWwgc2Vj dXJpdHkgYmVpbmcgaW5jb25zaXN0ZW50IGRlcGVuZGluZyBvbiB0aGUgbnVtYmVyIG9mIGluc2Vy dHMgdGhhdApoYXZlIHByZXZpb3VzbHkgYmVlbiBtYWRlIHRvIHRoZSB0YWJsZSB3aGljaCB0aGUg dHJpZ2dlciBpcyBhdHRhY2hlZCB0by4gSQp3aWxsIGF0dGFjaCBmdWxsIGEgY29kZSByZXByb2R1 Y3Rpb24gYXQgdGhlIGVuZCBvZiB0aGUgaXNzdWUuDQoNCk91ciBleHBlY3RhdGlvbiBpcyB0aGF0 IGEgdHJpZ2dlciB3aGljaCBjYWxscyBSTFMgd2hpY2ggdGhyb3dzIGFuIGV4Y2VwdGlvbgpzaG91 bGQgYWx3YXlzIHRocm93IGFuIGV4Y2VwdGlvbi4gQnV0IG91ciBvYnNlcnZlZCBiZWhhdmlvdXIg aXMgdGhhdCB0aGlzIGlzCm9ubHkgdGhlIGNhc2Ugc3RyYWlnaHQgYWZ0ZXIgdGhlIHRhYmxlIGhh cyBiZWVuIG1hZGUsIGFuZCBhZnRlciBzb21lIG51bWJlcgpvZiBpbnNlcnRzIChhdCBsZWFzdCA2 KSB0aGUgdHJpZ2dlciBzdG9wcyB0aHJvd2luZyBhbiBleGNlcHRpb24gZXZlbiB3aGVuCnRoZSBS TFMgcG9saWN5IHNob3VsZCB0aHJvdyBhbiBleGNlcHRpb24NCg0KSSBjcmVhdGUgdHdvIHRhYmxl cyAoYG5vX3Jsc190YWJsZWAgYW5kIGBybHNfdGFibGVgKS4gVGhlc2UgdGFibGVzIGJvdGggaGF2 ZQphIGNvbHVtbiBjYWxsZWQgYHNob3VsZF9ub3RfZHVwbGljYXRlYCB3aGVyZSB0aGUgYWltIGlz IHRoYXQgd2UgYmxvY2sKaW5zZXJ0cyBpbnRvIG9uZSB0YWJsZSBpZiB0aGUgb3RoZXIgdGFibGUg aGFzIHRoZSBzYW1lIHZhbHVlIGFscmVhZHkKZXhpc3RpbmcuDQoNCmBub19ybHNfdGFibGVgIGhh cyBub3QgZ290IGFueSBSTFMgb24gaXQgYW5kIHRoZSBhcHAgdXNlciBoYXMgZnVsbApwZXJtaXNz aW9ucyBvbiBpdA0KYHJsc190YWJsZWAgaGFzIFJMUyBvbiBpdCB3aGljaCBjaGVja3MgaWYgdGhl IGB0ZWFtX2lkYCAodXVpZCB0eXBlKSBjb2x1bW4KbWF0Y2hlcyBhIHNldHRpbmcgY2FsbGVkIGB0 ZWFtLnRlYW1faWRgICh3aGljaCB3ZSBjaGVjayB1c2luZwpgY3VycmVudF9zZXR0aW5nYCkuIFdo ZW4gYHRlYW0udGVhbV9pZGAgaXMgbWlzc2luZyB3ZSBleHBlY3QgdGhlIFJMUyB0bwp0aHJvdyBh biBleGNlcHRpb24gKGJlY2F1c2UgUG9zdGdyZXMgcmVhZHMgaXQgYXMgYW4gZW1wdHkgc3RyaW5n IGFuZCBhbgplbXB0eSBzdHJpbmcgY2FuJ3QgYmUgY29udmVydGVkIHRvIGEgVVVJRCkuDQoNCldl IHRoZW4gYWRkIGEgdHJpZ2dlciB0byBgbm9fcmxzX3RhYmxlYCB3aGljaCBjaGVja3MgZm9yIGV2 ZXJ5IHJvdyBpbnNlcnRlZAppZiB0aGUgdmFsdWUgYWxyZWFkeSBleGlzdHMgaW4gYHJsc190YWJs ZWAuIElmIGl0IGRvZXMgdGhlbiB3ZSByYWlzZSBhbgpleGNlcHRpb24sIG90aGVyd2lzZSBjb250 aW51ZSB3aXRoIHRoZSBpbnNlcnQuDQoNCigxKSBBcyBleHBlY3RlZCwgd2UgY2FuIGNvcnJlY3Rs eSBJTlNFUlQgaW50byBgbm9fcmxzX3RhYmxlYCBpZiB3ZSB1c2UgYFNFVApMT0NBTCB0ZWFtLnRl YW1faWQgPSAnNmE0M2NlYTgtNGE1Yy00OTg5LWJhZTItZWY1YTc3ZDkyNjIwJ2ANCigyKSBBbmQg YWdhaW4sIGFzIGV4cGVjdGVkIHRoZSBJTlNFUlQgaW50byBgbm9fcmxzX3RhYmxlYCB3aWxsIGZh aWwgd2l0aCBhbgpleGNlcHRpb24gaWYgd2UgZG9uJ3Qgc2V0IGB0ZWFtLnRlYW1faWRgIHRvIGEg dmFsdWUNCg0KKDMpIEhPV0VWRVIsIGlmIHdlIHRoZW4gZG8gYSBidW5jaCAoNispIG9mIGluc2Vy dHMgaW50byB0aGUgYG5vX3Jsc190YWJsZWAKd2Ugb2JzZXJ2ZSBkaWZmZXJlbnQgYmVoYXZpb3Vy cyBmb3IgdGhlIGFib3ZlLg0KKDQpIFNwZWNpZmljYWxseSwgd2Ugbm93IHRyeSBhbmQgZG8gYW4g SU5TRVJUIHdpdGhvdXQgc2V0dGluZyBgdGVhbS50ZWFtX2lkYAphbmQgd2UgZXhwZWN0IHRoZSBi ZWhhdmlvdXIgdG8gYmUgYSB0aHJvd24gZXhjZXB0aW9uIGFzIHdhcyB0aGUgY2FzZSBhYm92ZSwK YnV0IG5vdyB0aGUgSU5TRVJUIGNvbXBsZXRlcyB3aXRoIG5vIGV4Y2VwdGlvbnMuIA0KDQpJdCB3 YXMgb3VyIHVuZGVyc3RhbmRpbmcgdGhhdCB0aGUgUkxTIGZ1bmN0aW9uIGlzIHRoZSBmaXJzdCB0 aGluZyB0aGF0IGlzCmNhbGxlZCBiZWZvcmUgYWNjZXNzaW5nIGFueSB0YWJsZSwgc28gd2Ugd291 bGQgZXhwZWN0IHRoZSB0cmlnZ2VyIHRvIEFMV0FZUwpmYWlsIGlmIHRoZXJlIGlzIG5vIGxvY2Fs IHZhcmlhYmxlIHNldCwgYnV0IHRoaXMgaXMgbm90IHRoZSBjYXNlIGlmIGl0CmZvbGxvd3MgYSBj aHVuayBvZiBpbnNlcnRzIGludG8gdGhlIHJlbGV2YW50IHRhYmxlLg0KDQpJIHdvdWxkIGJlIHZl cnkgZ3JhdGVmdWwgaWYgYW55b25lIHdhcyBhYmxlIHRvIGhlbHAgcHJvdmlkZSBzb21lIGxpZ2h0 IG9uCnRoaXMgc2l0dWF0aW9uISBXZSBoYXZlIHRlc3RlZCB0aGlzIG9uIHYxNC41LCAxNi42IGFu ZCAxNy4yIGFuZCBmb3VuZApjb25zaXN0ZW50IGJlaGF2aW91cg0KDQpGdWxsIGNvZGUgdG8gcmVw cm9kdWNlIHRoZSBzY2VuYXJpbw0KYGBgc3FsDQotLSBDcmVhdGUgbGVzcyBwcml2aWxlZ2VkIHVz ZXINCkNSRUFURSBVU0VSIGFwcF91c2VyOw0KDQotLSBDcmVhdGUgdGFibGUgd2hpY2ggaGFzIG5v IFJvdyBsZXZlbCBzZWN1cml0eSBhbmQgZ2l2ZSBuZWNlc3NhcnkKcGVybWlzc2lvbnMgdG8gYXBw IHVzZXINCkNSRUFURSBUQUJMRSBub19ybHNfdGFibGUNCigNCiAgICBpZCBCSUdTRVJJQUwgUFJJ TUFSWSBLRVksDQogICAgc2hvdWxkX25vdF9kdXBsaWNhdGUgdXVpZA0KKTsNCkdSQU5UIFNFTEVD VCwgSU5TRVJULCBERUxFVEUgT04gVEFCTEUgbm9fcmxzX3RhYmxlIHRvIGFwcF91c2VyOw0KR1JB TlQgVVNBR0UsIFNFTEVDVCBPTiBTRVFVRU5DRSBub19ybHNfdGFibGVfaWRfc2VxIHRvIGFwcF91 c2VyOw0KDQotLSBDcmVhdGUgdGFibGUgd2hpY2ggaGFzIHJvdyBsZXZlbCBzZWN1cml0eSBiYXNl ZCBvbiBsb2NhbCBzZXR0aW5ncwoodGVhbS50ZWFtX2lkKQ0KQ1JFQVRFIFRBQkxFIHJsc190YWJs ZQ0KKA0KICAgIGlkIEJJR1NFUklBTCBQUklNQVJZIEtFWSwNCiAgICB0ZWFtX2lkIHV1aWQsDQog ICAgc2hvdWxkX25vdF9kdXBsaWNhdGUgdXVpZA0KKTsNCkdSQU5UIFNFTEVDVCwgSU5TRVJULCBE RUxFVEUgT04gVEFCTEUgcmxzX3RhYmxlIHRvIGFwcF91c2VyOw0KR1JBTlQgVVNBR0UsIFNFTEVD VCBPTiBTRVFVRU5DRSBybHNfdGFibGVfaWRfc2VxIHRvIGFwcF91c2VyOw0KDQpDUkVBVEUgUE9M SUNZIHJsc190YWJsZV9wb2xpY3kNCiAgICBPTiBybHNfdGFibGUNCiAgICBUTyBhcHBfdXNlcg0K ICAgIFVTSU5HICgNCiAgICAgICAgdGVhbV9pZCA9IGN1cnJlbnRfc2V0dGluZygndGVhbS50ZWFt X2lkJykgOjogdXVpZA0KICAgICAgICApDQogICAgV0lUSCBDSEVDSyAoDQogICAgICAgIHRlYW1f aWQgPSBjdXJyZW50X3NldHRpbmcoJ3RlYW0udGVhbV9pZCcpIDo6IHV1aWQNCiAgICApOw0KDQpB TFRFUiBUQUJMRSBybHNfdGFibGUgRU5BQkxFIFJPVyBMRVZFTCBTRUNVUklUWTsNCg0KLS0gQWRk IGEgdHJpZ2dlciBvbiB0aGUgbm9fcmxzX3RhYmxlIHdoaWNoIGNoZWNrcyBpZiB0aGUgcmxzX3Rh YmxlIGhhcyBhCnBhcnRpY3VsYXIgdmFsdWUNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIGVu c3VyZV9ub3RfZHVwbGljYXRlZF9vbl9ybHNfdGFibGUoKSBSRVRVUk5TClRSSUdHRVIgQVMNCiQk DQogICAgQkVHSU4NCiAgICAgICAgSUYgRVhJU1RTICgNCiAgICAgICAgICAgIFNFTEVDVCAxDQog ICAgICAgICAgICBGUk9NIHJsc190YWJsZQ0KICAgICAgICAgICAgV0hFUkUgcmxzX3RhYmxlLnNo b3VsZF9ub3RfZHVwbGljYXRlID0KTkVXLnNob3VsZF9ub3RfZHVwbGljYXRlDQogICAgICAgICkN CiAgICAgICAgVEhFTg0KICAgICAgICAgICAgUkFJU0UgRVhDRVBUSU9OICdUaGlzIHZhbHVlIHNo b3VsZCBub3QgYmUgZHVwbGljYXRlZCBiZXR3ZWVuIHRoZQp0d28gdGFibGVzJzsNCiAgICAgICAg RU5EIElGOw0KDQogICAgICAgIFJFVFVSTiBORVc7DQogICAgRU5EOw0KJCQgTEFOR1VBR0UgcGxw Z3NxbDsNCg0KQ1JFQVRFIFRSSUdHRVIgY2hlY2tfbm90X2R1cGxpY2F0ZWRfb25fcmxzX3RhYmxl DQogICAgQkVGT1JFIElOU0VSVCBPUiBVUERBVEUgT04gbm9fcmxzX3RhYmxlDQogICAgRk9SIEVB Q0ggUk9XDQpFWEVDVVRFIFBST0NFRFVSRSBlbnN1cmVfbm90X2R1cGxpY2F0ZWRfb25fcmxzX3Rh YmxlKCk7DQoNCi0tICgxKSBPbmUgSU5TRVJUIHRvIGRlbW9uc3RyYXRlIGl0IHdvcmtzIGNvcnJl Y3RseSB3aXRoIGEgbG9jYWwgdGVhbQ0KQkVHSU47DQpTRVQgUk9MRSBhcHBfdXNlcjsNClNFVCBM T0NBTCB0ZWFtLnRlYW1faWQgPSAnNmE0M2NlYTgtNGE1Yy00OTg5LWJhZTItZWY1YTc3ZDkyNjIw JzsNCklOU0VSVCBJTlRPIG5vX3Jsc190YWJsZSAoc2hvdWxkX25vdF9kdXBsaWNhdGUpIFZBTFVF UyAoCmdlbl9yYW5kb21fdXVpZCgpKTsNCkNPTU1JVDsNCg0KLS0gKDIpIFRyeSBhbmQgaW5zZXJ0 IGludG8gbm9fcmxzX3RhYmxlIGFuZCBpdCBmYWlscyBpZiBpdCBoYXMgbm8KdGVhbS50ZWFtX2lk DQpCRUdJTjsNClNFVCBST0xFIGFwcF91c2VyOw0KIC0tIFRoaXMgY29tbWFuZCB3aWxsIGZhaWwg d2l0aCBhbiBleGNlcHRpb24gYFsyMlAwMl0gRVJST1I6IGludmFsaWQgaW5wdXQKc3ludGF4IGZv ciB0eXBlIHV1aWQ6ICIiYA0KSU5TRVJUIElOVE8gbm9fcmxzX3RhYmxlIChzaG91bGRfbm90X2R1 cGxpY2F0ZSkgVkFMVUVTICgKZ2VuX3JhbmRvbV91dWlkKCkpOw0KQ09NTUlUOw0KDQotLSAoMykg RG8gYSBidW5jaCBvZiBpbnNlcnRzIGludG8gbm9fcmxzX3RhYmxlIHdpdGggdGVhbS50ZWFtX2lk IHNvIHRoZXNlCndvcmsgY29ycmVjdGx5DQpCRUdJTjsNClNFVCBST0xFIGFwcF91c2VyOw0KU0VU IExPQ0FMIHRlYW0udGVhbV9pZCA9ICc2YTQzY2VhOC00YTVjLTQ5ODktYmFlMi1lZjVhNzdkOTI2 MjAnOw0KSU5TRVJUIElOVE8gbm9fcmxzX3RhYmxlIChzaG91bGRfbm90X2R1cGxpY2F0ZSkgVkFM VUVTICgKZ2VuX3JhbmRvbV91dWlkKCkpOw0KSU5TRVJUIElOVE8gbm9fcmxzX3RhYmxlIChzaG91 bGRfbm90X2R1cGxpY2F0ZSkgVkFMVUVTICgKZ2VuX3JhbmRvbV91dWlkKCkpOw0KSU5TRVJUIElO VE8gbm9fcmxzX3RhYmxlIChzaG91bGRfbm90X2R1cGxpY2F0ZSkgVkFMVUVTICgKZ2VuX3JhbmRv bV91dWlkKCkpOw0KSU5TRVJUIElOVE8gbm9fcmxzX3RhYmxlIChzaG91bGRfbm90X2R1cGxpY2F0 ZSkgVkFMVUVTICgKZ2VuX3JhbmRvbV91dWlkKCkpOw0KSU5TRVJUIElOVE8gbm9fcmxzX3RhYmxl IChzaG91bGRfbm90X2R1cGxpY2F0ZSkgVkFMVUVTICgKZ2VuX3JhbmRvbV91dWlkKCkpOw0KSU5T RVJUIElOVE8gbm9fcmxzX3RhYmxlIChzaG91bGRfbm90X2R1cGxpY2F0ZSkgVkFMVUVTICgKZ2Vu X3JhbmRvbV91dWlkKCkpOw0KQ09NTUlUOw0KDQotLSAoNCkgVHJ5IGFuZCBpbnNlcnQgdGhlIG5v X3Jsc190YWJsZSB3aXRob3V0IHRlYW0udGVhbV9pZCBhZ2FpbiBhbmQgdGhpcwp0aW1lIG5vIGV4 Y2VwdGlvbiBpcyB0aHJvd24uIFRISVMgSVMgVEhFIFVORVhQRUNURUQgQkVIQVZJT1VSDQpCRUdJ TjsNClNFVCBST0xFIGFwcF91c2VyOw0KSU5TRVJUIElOVE8gbm9fcmxzX3RhYmxlIChzaG91bGRf bm90X2R1cGxpY2F0ZSkgVkFMVUVTICgKZ2VuX3JhbmRvbV91dWlkKCkpOw0KQ09NTUlUOw0KDQot LSBDbGVhbnVwIFBoYXNlDQpSRVNFVCBST0xFOw0KRFJPUCBUQUJMRSBybHNfdGFibGU7DQpEUk9Q IFRBQkxFIG5vX3Jsc190YWJsZTsNCmBgYAoK --===============0227115055022207516==--