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.96) (envelope-from ) id 1vWLQC-00HJOq-0s for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Dec 2025 21:20:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vWLQA-004Keg-2n for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Dec 2025 21:20:27 +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.96) (envelope-from ) id 1vWFXz-002iJi-0J for pgsql-bugs@lists.postgresql.org; Thu, 18 Dec 2025 15:04:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vWFXx-001Qnn-0y for pgsql-bugs@lists.postgresql.org; Thu, 18 Dec 2025 15:04:07 +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=eYbQAYyCaKpkLys7y6gir/zdkKn0+P16Aumrr5gsJ54=; b=Uho3cE1IrfC3+4d104p9bchynN hLsGgctv1DXZctcrodBEutQl6m1N9rKkEDpAyM3WVLuOdrdbMq89JscwvIlGL8dDBpDcp6Gglb8CM Eodc3wZ1+xBgGRJPdYOEMi+3sukOiK/nsIrLVOVlvxceAYQ5BDNEvoi6OA5i2NXywC0a0nmoTAvWp IVL6Rj+BXL7qMx3P9iyznYVrZYR6tXMp2LMHT8kV8zjsj3wj61BM4KjLbQ+unuDz3Fy1w92d4cOb+ pZbIRsilCKps4tix/oqGXB/J0dFJc30zXnMcIc3VAuh+K9VMzUIB0cYsR4qcxMkqs6WX/5GoF6/7l mL3W9tIw==; 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.96) (envelope-from ) id 1vWFXw-003ujL-1a for pgsql-bugs@lists.postgresql.org; Thu, 18 Dec 2025 15:04:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vWFXu-007EPu-0V for pgsql-bugs@lists.postgresql.org; Thu, 18 Dec 2025 15:04:02 +0000 Content-Type: multipart/mixed; boundary="===============9187839917737556663==" MIME-Version: 1.0 Subject: BUG #19359: Row level security: Upserts require insert policies in the update path To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: elena@cedardb.com Reply-To: elena@cedardb.com, pgsql-bugs@lists.postgresql.org Date: Thu, 18 Dec 2025 15:03:28 +0000 Message-ID: <19359-fb1d273ab01b8b22@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 --===============9187839917737556663== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM1OQpMb2dnZWQgYnk6ICAgICAgICAgIEVsZW5hIEtyaXBwbmVyCkVt YWlsIGFkZHJlc3M6ICAgICAgZWxlbmFAY2VkYXJkYi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx OC4xCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDI1LjEwCkRlc2NyaXB0aW9uOiAgICAgICAg CgpUaGUgZG9jdW1lbnRhdGlvbiBvbiBwb2xpY2llcwooaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvZG9jcy9jdXJyZW50L3NxbC1jcmVhdGVwb2xpY3kuaHRtbCkgc2F5cyBmb3IKdXBzZXJ0czoK Tm90ZSB0aGF0IElOU0VSVCB3aXRoIE9OIENPTkZMSUNUIERPIFVQREFURSBjaGVja3MgSU5TRVJU IHBvbGljaWVzJyBXSVRICkNIRUNLIGV4cHJlc3Npb25zIG9ubHkgZm9yIHJvd3MgYXBwZW5kZWQg dG8gdGhlIHJlbGF0aW9uIGJ5IHRoZSBJTlNFUlQgcGF0aC4KCkluIHRoaXMgY2FzZSwgdGhlIHVw ZGF0ZSBwYXRoIGlzIHRha2VuLCBidXQgdGhlIHZhbHVlcyBjYW4gb25seSBiZSB1cHNlcnRlZAph ZnRlciBhZGRpbmcgYW4gaW5zZXJ0IHBvbGljeToKcm9vdEA0Mjg0YjY2YjQzYmU6LyMgcHNxbCAt aCBsb2NhbGhvc3QgLVUgcG9zdGdyZXMKcHNxbCAoMTguMSAoRGViaWFuIDE4LjEtMS5wZ2RnMTMr MikpClR5cGUgImhlbHAiIGZvciBoZWxwLgoKcG9zdGdyZXM9IyBjcmVhdGUgdGFibGUgdCAoYSBp bnRlZ2VyIHByaW1hcnkga2V5KTsKQ1JFQVRFIFRBQkxFCnBvc3RncmVzPSMgaW5zZXJ0IGludG8g dCB2YWx1ZXMgKDEpLCAoMiksICgzKTsKSU5TRVJUIDAgMwpwb3N0Z3Jlcz0jIGNyZWF0ZSByb2xl IHBvbGljeV9yb2xlOwpDUkVBVEUgUk9MRQpwb3N0Z3Jlcz0jIGdyYW50IHNlbGVjdCwgaW5zZXJ0 LCB1cGRhdGUsIGRlbGV0ZSBvbiB0IHRvIHBvbGljeV9yb2xlOwpHUkFOVApwb3N0Z3Jlcz0jIGFs dGVyIHRhYmxlIHQgZW5hYmxlIHJvdyBsZXZlbCBzZWN1cml0eTsKQUxURVIgVEFCTEUKcG9zdGdy ZXM9IyBjcmVhdGUgcG9saWN5IHRfYUxlc3M0IG9uIHQgZm9yIHVwZGF0ZSB1c2luZyAodHJ1ZSkg d2l0aCBjaGVjayAoYQo8IDQpOwpDUkVBVEUgUE9MSUNZCnBvc3RncmVzPSMgY3JlYXRlIHBvbGlj eSB0X3NlbGVjdCBvbiB0IGZvciBzZWxlY3QgdXNpbmcgKHRydWUpOwpDUkVBVEUgUE9MSUNZCnBv c3RncmVzPSMgc2V0IHJvbGUgcG9saWN5X3JvbGU7ClNFVApwb3N0Z3Jlcz0+IHNlbGVjdCAqIGZy b20gdCBvcmRlciBieSBhOwogYQotLS0KIDEKIDIKIDMKKDMgcm93cykKCnBvc3RncmVzPT4gaW5z ZXJ0IGludG8gdCB2YWx1ZXMgKDEpIG9uIGNvbmZsaWN0IChhKSBkbyB1cGRhdGUgc2V0IGEgPSAw OwpFUlJPUjogIG5ldyByb3cgdmlvbGF0ZXMgcm93LWxldmVsIHNlY3VyaXR5IHBvbGljeSBmb3Ig dGFibGUgInQiCnBvc3RncmVzPT4gc2V0IHJvbGUgcG9zdGdyZXM7ClNFVApwb3N0Z3Jlcz0jIGNy ZWF0ZSBwb2xpY3kgdF9pbnNlcnQgb24gdCBmb3IgaW5zZXJ0IHdpdGggY2hlY2sgKHRydWUpOwpD UkVBVEUgUE9MSUNZCnBvc3RncmVzPSMgc2V0IHJvbGUgcG9saWN5X3JvbGU7ClNFVApwb3N0Z3Jl cz0+IGluc2VydCBpbnRvIHQgdmFsdWVzICgxKSBvbiBjb25mbGljdCAoYSkgZG8gdXBkYXRlIHNl dCBhID0gMDsKSU5TRVJUIDAgMQpwb3N0Z3Jlcz0+IHNlbGVjdCAqIGZyb20gdCBvcmRlciBieSBh OwogYQotLS0KIDAKIDIKIDMKKDMgcm93cykKCg== --===============9187839917737556663==--