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 1ukN6X-001XPT-4Z for pgsql-bugs@arkaria.postgresql.org; Fri, 08 Aug 2025 13:25:53 +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 1ukN6V-00DtUf-O3 for pgsql-bugs@arkaria.postgresql.org; Fri, 08 Aug 2025 13:25:51 +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 1uk6jb-00AMsc-SB for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 19:57:08 +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 1uk6jY-001H0N-2p for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 19:57:06 +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=d+h5paJA1TMr82uYC6FVVjqrumwVIhrrMMHwJqTJOQw=; b=FxmlHFgCfuKtBpg7zHdaega9PS NbujbGrXI0GAKHgY0wQILEtxCqBmX9Aw95uRIH2X8GQJ0cogtSr0VrW/c5/zbk/mO8N7ljv3b84Kh aF94bK7fIBN+UNVw5nNBNFBem3yYXMDH/oUvwT4NeLoaPfPnlRPb7gbdvSOnNJ5RQoTeAANLMt8JB FMEkVD3ulzF1kRfrd3/UAgPiZIrFV9TtnsVnn1BJ+ISQOfs0QbLB8tDPLZstvMUyeqzIVG6djYrD8 Gni4m7mEQM1H/egCZl0G13yvzdGSLPlUoAcTqqLzhtyuy9rJ/G7fiMMEN68OB2CrYlZM9cgbhw50O 8BhlAQ/Q==; 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 1uk6jY-003R7U-6Y for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 19:57:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uk6jW-006ZKA-1k for pgsql-bugs@lists.postgresql.org; Thu, 07 Aug 2025 19:57:02 +0000 Content-Type: multipart/mixed; boundary="===============3436654331908379236==" MIME-Version: 1.0 Subject: BUG #19015: insert-returning failure: stable function in select policy doesn't see before-insert trigger change To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: di@nmfay.com Reply-To: di@nmfay.com, pgsql-bugs@lists.postgresql.org Date: Thu, 07 Aug 2025 19:56:35 +0000 Message-ID: <19015-361c9035ff9d47d0@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 --===============3436654331908379236== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAxNQpMb2dnZWQgYnk6ICAgICAgICAgIERpYW4gRmF5CkVtYWlsIGFk ZHJlc3M6ICAgICAgZGlAbm1mYXkuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMThiZXRhMgpPcGVy YXRpbmcgc3lzdGVtOiAgIExpbnV4IHg2NApEZXNjcmlwdGlvbjogICAgICAgIAoKVGhpcyBzY3Jp cHQgaXMgYSBtaW5pbWFsIGV4YW1wbGUgb2YgYSBzeXN0ZW0gdGhhdCB1c2VzIHJvdy1sZXZlbCBz ZWN1cml0eQp3aXRoIGFuIGFjY2Vzcy1jb250cm9sIGxpc3QgdGFibGUgYW5kIGEgcG9saWN5IG9u IGFuIFJMUy1lbmFibGVkIHRhYmxlCmludm9raW5nIGEgZnVuY3Rpb24gdG8gY2hlY2sgdGhlIHVz ZXIncyBBQ0wgb24gcmVhZC4gVGhlIGludGVudCBpcyBmb3IKdXNlcnMnIHZpc2liaWxpdHkgb24g cmVjb3JkcyBpbiB0aGUgYHRlc3RgIHRhYmxlIHRvIGJlIHJlc3RyaWN0ZWQgdG8gdGhvc2UKZm9y IHdoaWNoIHRoZXkgaGF2ZSBhbiBBQ0wgZW50cnk7IGhvd2V2ZXIsIGFueSB1c2VyIHNob3VsZCBi ZSBhYmxlIHRvCl9pbnNlcnRfIGEgbmV3IGB0ZXN0YCByZWNvcmQsIGFuZCBhbiBBQ0wgZW50cnkg aXMgYXV0b21hdGljYWxseSBnZW5lcmF0ZWQgYnkKYSBgYmVmb3JlIGluc2VydGAgdHJpZ2dlci4K ClRoZXJlIGlzIGEgc3VycHJpc2luZyBpbnRlcmFjdGlvbiBiZXR3ZWVuIGZ1bmN0aW9uIHZvbGF0 aWxpdHkgYW5kIHRoZSB1c2Ugb2YKYHJldHVybmluZ2AuIFNwZWNpZmljYWxseSwgX2lmXyB0aGUg YGNhbl9yZWFkYCBmdW5jdGlvbiBpbiB0aGUgYGZvciBzZWxlY3RgCnBvbGljeSBpcyBtYXJrZWQg YHN0YWJsZWAsIF9hbmRfIGFuIGluc2VydCBpbnRvIGB0ZXN0YCBoYXMgYSBgcmV0dXJuaW5nYApj bGF1c2UgKGluY2x1ZGVkIGF0IHRoZSBlbmQgb2YgdGhlIGZvbGxvd2luZyBzY3JpcHQpLCB0aGUg c2VydmVyIGRlY2xhcmVzCnRoYXQgdGhlIG5ldyByb3cgdmlvbGF0ZXMgYW4gdW5uYW1lZCBSTFMg cG9saWN5OgoKPiBFUlJPUjogIG5ldyByb3cgdmlvbGF0ZXMgcm93LWxldmVsIHNlY3VyaXR5IHBv bGljeSBmb3IgdGFibGUgInRlc3QiCgpJZiB0aGUgaW5zZXJ0IGRvZXMgbm90IHJldHVybiB2YWx1 ZXMsIHRoZSBmdW5jdGlvbiBjYW4gYmUgYHN0YWJsZWA7IGlmIHRoZQpmdW5jdGlvbiBpcyBgdm9s YXRpbGVgLCB0aGUgaW5zZXJ0IHdpdGggYHJldHVybmluZ2Agc3VjY2VlZHMuCgpUaGVyZSdzIG5v IGltbWVkaWF0ZSByZWFzb24gdG8gY2hlY2sgQUNMcyBhdCBhbnkgcG9pbnQgaW4gdGhlIHRyYW5z YWN0aW9uCmJlZm9yZSB0aGUgbmV3IEFDTCBpcyByZWdpc3RlcmVkLCBzbyBgc3RhYmxlYCBzaG91 bGQgaW4gdGhlb3J5IGJlIHRoZQphcHByb3ByaWF0ZSB2b2xhdGlsaXR5IGxldmVsLiBJdCdzIGRl ZmluaXRlbHkgZGVzaXJhYmxlOyBpbiB0aGlzIGV4YW1wbGUKd2UncmUgY2FsbGluZyBgY2FuX3Jl YWRgIHdpdGggYSBkaWZmZXJlbnQgdmFsdWUgZm9yIGV2ZXJ5IHR1cGxlLCBidXQgaW4gdGhlCm9y aWdpbmFsIHN5c3RlbSB3ZSBwYXNzIGl0IGEgbXVjaCBtb3JlIGxpbWl0ZWQgc2V0IG9mIHBhcmVu dCBpZHMsIGFuZApyZWR1bmRhbnQgZXhlY3V0aW9uIGFkZHMgdXAgcXVpY2tseS4KCkZvbGxvd2lu ZyBFeGVjSW5zZXJ0LCBJIHNlZSB0aGUgYGJlZm9yZSBpbnNlcnRgIHRyaWdnZXJzIGZpcmluZyBi ZWZvcmUgaXQKY2hlY2tzIFJMUyBwb2xpY2llcy4gV2hlbiBpdCBkb2VzIGdldCB0byB0aGUgRXhl Y1dpdGhDaGVja09wdGlvbnMgY2FsbCwKYHJlc3VsdFJlbEluZm9gIGhhcyByaV9XaXRoQ2hlY2tP cHRpb25zIGFuZCByaV9XaXRoQ2hlY2tPcHRpb25FeHBycy4gVGhlCmZvcm1lciBXQ08gaGFzIG5v IGBwb2xuYW1lYCBidXQgaXMgYSBXQ09fUkxTX0lOU0VSVF9DSEVDSy4gVGhlIGV4cHIgaXMgYQpG dW5jRXhwciByZXByZXNlbnRpbmcgYGNhbl9yZWFkYCBmcm9tIHRoZSBgZm9yIHNlbGVjdGAgcG9s aWN5LiBTaW5jZSB0aGUKYGJlZm9yZWAgdHJpZ2dlcnMgaGF2ZSBhbHJlYWR5IHJ1biBhbmQgcmVn aXN0ZXJlZCBhbiBBQ0wgZm9yIHRoaXMgcmVjb3JkLAphbmQgYmVjYXVzZSB0aGlzIGlzIHRoZSBm aXJzdCB0aW1lIGBjYW5fcmVhZGAgZXhlY3V0ZXMsIGl0IHNob3VsZCBzZWUgdGhlCkFDTCBlbnRy eSwgYnV0IGRvZXMgbm90IHVubGVzcyBtYXJrZWQgYHZvbGF0aWxlYC4KCklmIEkgb21pdCB0aGUg YHJldHVybmluZ2AsIHJpX1dpdGhDaGVja09wdGlvbnMgaXMgbmlsOyBJJ20gZ3Vlc3NpbmcgdGhl CmRlYWQtc2ltcGxlIGB0cnVlYCBwb2xpY3kgZm9yIGluc2VydCB3YXMgaW5saW5lZCBvciBkaXNj YXJkZWQgYXQgc29tZSBwb2ludAooaXQncyB0aGVyZSBpbiBmaXJlUklScnVsZXMpLCBidXQgaGF2 ZW4ndCB0cmFja2VkIGl0IGRvd24uCgpRdWVzdGlvbnM6CgotIHRoZSBmYWN0IHRoYXQgYSBgdm9s YXRpbGVgIGZ1bmN0aW9uIGNhbiBzZWUgdGhlIEFDTCBlbnRyeSBzdWdnZXN0cyB0aGF0Cml0J3Mg YmVpbmcgZXhlY3V0ZWQgYmVmb3JlIHRoZSBBQ0wgcmVnaXN0cmF0aW9uIHRyaWdnZXIgYW5kIGEg YHN0YWJsZWAKcmVzdWx0IGlzIGNhY2hlZCBhbmQgcmV1c2VkLiBgZXhwbGFpbmAgZG9lcyBzaG93 IGFuIEluaXRQbGFuIHRoYXQgc2VlbXMgYQpiaXQgc3VzcGVjdCwgYnV0IHN0ZXBwaW5nIGludG8g RXhlY1dpdGhDaGVja09wdGlvbnMgLT4gRXhlY1F1YWwgd2l0aCB0aGUKZnVuY3Rpb24gbWFya2Vk IGBzdGFibGVgIHNob3dzIGFuIEluZGV4U2NhbiBoYXBwZW5pbmcuIFRoYXQgc2VlbXMgdG8gY29u ZmlybQp0aGF0IGBjYW5fcmVhZGAgaXMgZXhlY3V0ZWQgb25seSBhZnRlciB0aGUgdHJpZ2dlciBp bnNlcnRzIGFuIEFDTCBlbnRyeS4gV2h5CmRvZXMgdGhlIHN0YWJsZSBgY2FuX3JlYWRgIG5vdCBz ZWUgaXQ/Ci0gc2V0dGluZyB0aGUgbWFpbiBpc3N1ZSBhc2lkZSwgaXQgaXMgYWxyZWFkeSBwb3Nz aWJsZSB0byBpbnNlcnQgcmVjb3Jkcwp0aGF0IGEgYGZvciBzZWxlY3RgIHBvbGljeSBkb2Vzbid0 IGFsbG93IHlvdSB0byBzZWUgaW4gYSBzdWJzZXF1ZW50IHF1ZXJ5LgpTaG91bGQgYSB2aW9sYXRp b24gb2YgdGhlIGBmb3Igc2VsZWN0YCBwb2xpY3kgYnkgYSBgcmV0dXJuaW5nYCBjbGF1c2UgeWll bGQKYW4gZW1wdHkgcmVzdWx0IGluc3RlYWQgb2Ygc2N1cHBlcmluZyB0aGUgaW5zZXJ0IHRvIGJl IGNvbnNpc3RlbnQ/CgpJIGVuY291bnRlcmVkIHRoZSBwcm9ibGVtIGluIDE1LjEyIGJ1dCBkaWQg dGhlIGRlYnVnZ2luZyBhZ2FpbnN0IG1hc3Rlci4gSSdtCmludGVyZXN0ZWQgaW4gaGFja2luZyBv biB0aGlzIGJ1dCBhbSBub3QgcmVhbGx5IHN1cmUgd2hlcmUgdG8gbG9vayBuZXh0IC0tCmV2ZW4g YWNjb3VudGluZyBmb3IgdGhlIGBmb3Igc2VsZWN0YCBwb2xpY3kgcXVhbCBiZWluZyBwdWxsZWQg dXAgaW50byBhCldpdGhDaGVja09wdGlvbiBvbiB0aGUgaW5zZXJ0LCBpdCBzZWVtcyBsaWtlIGl0 J3MgdGVzdGluZyBXQ09zIGFmdGVyIHRoZQp0cmlnZ2VyLgoKLS0gY3JlYXRlIHJvbGUgInRlYW0t bWVtYmVyIjsKZHJvcCB0YWJsZSBpZiBleGlzdHMgdGVzdDsKZHJvcCBmdW5jdGlvbiBpZiBleGlz dHMgY2FuX3JlYWQ7CmRyb3AgZnVuY3Rpb24gaWYgZXhpc3RzIHJlZ2lzdGVyX2FjbDsKZHJvcCB0 YWJsZSBpZiBleGlzdHMgYWNsOwoKY3JlYXRlIHRhYmxlIHRlc3QgKAogICAgaWQgaW50IGdlbmVy YXRlZCBhbHdheXMgYXMgaWRlbnRpdHkgcHJpbWFyeSBrZXksCiAgICBudW0gaW50LAogICAgdmFs IHRleHQKKTsKY3JlYXRlIHRhYmxlIGFjbCAoCiAgICBpdGVtIGludCwKICAgIHRlYW0gdGV4dCwK ICAgIGNhbl9yZWFkIGJvb2xlYW4sCiAgICBjYW5fd3JpdGUgYm9vbGVhbiwKICAgIHByaW1hcnkg a2V5IChpdGVtLCB0ZWFtKQopOwoKY3JlYXRlIGZ1bmN0aW9uIHJlZ2lzdGVyX2FjbCgpCiAgICBy ZXR1cm5zIHRyaWdnZXIKICAgIGxhbmd1YWdlIHBscGdzcWwKYXMgJCRiZWdpbgogICAgaW5zZXJ0 IGludG8gYWNsKGl0ZW0sIHRlYW0sIGNhbl9yZWFkLCBjYW5fd3JpdGUpCiAgICB2YWx1ZXMgKG5l dy5pZCwgY3VycmVudF9zZXR0aW5nKCdhc3N1bWVkX3JvbGUudGVhbScpLCB0cnVlLCB0cnVlKQog ICAgb24gY29uZmxpY3QgZG8gbm90aGluZzsKCiAgICByZXR1cm4gbmV3OwplbmQkJDsKCmNyZWF0 ZSB0cmlnZ2VyIHRlc3RfcmVnaXN0ZXJfYWNsIGJlZm9yZSBpbnNlcnQgb24gdGVzdApmb3IgZWFj aCByb3cgZXhlY3V0ZSBmdW5jdGlvbiByZWdpc3Rlcl9hY2woKTsKCmFsdGVyIHRhYmxlIHRlc3Qg ZW5hYmxlIHJvdyBsZXZlbCBzZWN1cml0eTsKCmdyYW50IHNlbGVjdCwgaW5zZXJ0IG9uIHRlc3Qg dG8gInRlYW0tbWVtYmVyIjsKZ3JhbnQgc2VsZWN0LCBpbnNlcnQgb24gYWNsIHRvICJ0ZWFtLW1l bWJlciI7CgpjcmVhdGUgZnVuY3Rpb24gY2FuX3JlYWQoX2l0ZW0gaW50LCBfdGVhbSB0ZXh0KQog ICAgcmV0dXJucyBib29sZWFuCiAgICBsYW5ndWFnZSBzcWwKICAgIC0tIGFzIGxvbmcgYXMgdGhl IGZpbmFsIGB0ZXN0YCBpbnNlcnQgYWRkcyBgcmV0dXJuaW5nYCwgdGhlIGBzdGFibGVgCiAgICAt LSBmdW5jdGlvbiBjYW5ub3Qgc2VlIGFjbHMgaW5zZXJ0ZWQgYnkgdGhlIGBiZWZvcmUgaW5zZXJ0 YCB0cmlnZ2VyLAogICAgLS0gd2hpbGUgYSBgdm9sYXRpbGVgIGZ1bmN0aW9uIGNhbgogICAgc3Rh YmxlCmJlZ2luIGF0b21pYwogICAgc2VsZWN0IGV4aXN0cyAoCiAgICAgICAgc2VsZWN0IDEgZnJv bSBhY2wKICAgICAgICB3aGVyZSBpdGVtID0gX2l0ZW0KICAgICAgICAgICAgYW5kIHRlYW0gPSBf dGVhbQogICAgICAgICAgICBhbmQgY2FuX3JlYWQgaXMgdHJ1ZQogICAgKTsKZW5kOwoKY3JlYXRl IHBvbGljeSB0ZXN0X3RtX3NlbGVjdCBvbiB0ZXN0IGZvciBzZWxlY3QgdG8gInRlYW0tbWVtYmVy IgotLSB1c2luZyAoCi0tICAgICAoc2VsZWN0IGNhbl9yZWFkKGlkLCAoc2VsZWN0IGN1cnJlbnRf c2V0dGluZygnYXNzdW1lZF9yb2xlLnRlYW0nKSkpKQotLSApOwp1c2luZyAoCiAgICBjYW5fcmVh ZChpZCwgKHNlbGVjdCBjdXJyZW50X3NldHRpbmcoJ2Fzc3VtZWRfcm9sZS50ZWFtJykpKQopOwoK Y3JlYXRlIHBvbGljeSB0ZXN0X3RtX2luc2VydCBvbiB0ZXN0IGZvciBpbnNlcnQgdG8gInRlYW0t bWVtYmVyIgp3aXRoIGNoZWNrICh0cnVlKTsKCnNldCByb2xlICJ0ZWFtLW1lbWJlciI7CnNlbGVj dCBzZXRfY29uZmlnKCdhc3N1bWVkX3JvbGUudGVhbScsICdkZW1vJywgZmFsc2UpOwoKZXhwbGFp bgppbnNlcnQgaW50byB0ZXN0KG51bSwgdmFsKSB2YWx1ZXMgKDEsICd0ZXN0JykKcmV0dXJuaW5n IGlkLCBudW0sIHZhbDsgLS0gd2l0aG91dCBgcmV0dXJuaW5nYCwgd2UgY2FuIGluc2VydCB3aXRo IHN0YWJsZQpjYW5fcmVhZAogICAgICAgICAgICAgLS0ganVzdCBmaW5lIHNpbmNlIHRoZSBzZWxl Y3QgcG9saWN5IG5ldmVyIGNvbWVzIGludG8gcGxheQoK --===============3436654331908379236==--