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 1v4NRp-00E2JF-8M for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Oct 2025 17:50:33 +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 1v4NRl-008ijr-RQ for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Oct 2025 17:50:30 +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 1v4J6T-007p1v-An for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 13:12:14 +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 1v4J6R-0012x1-04 for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 13:12:13 +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=Oe9LP0b5Q/5YpEXUlvIwYxcudyx0MlyqMMSpVRGR3LM=; b=R8La1BmB/zuscApr9erTQbmcDD LHjb9IYc+TrWcr+n4wBJKjkQGNKojvAiCFYNK354qF2SPiUduAu6+mKVllv3MZJZwOo8D7TN3rfcM zxrPzsRkhbmpmKFazPCl7gYQhXdGfa7GNInUtb6dqLwixHYdQUGvhVapdXPTwjElMV0XCRv9k8phH +tFLC+E1wDLwNv8W2NzNWVn1lEP7LxsL7Bz6CQWUStBAj58Gtwvs5pdFmrnv/uDL6981yo2Qldjip VDyTY6ibT8sSIOULBPR6Z4YBJEx7qxBQ/ABROxsgqTmtk6SZSNH6E991lao4iFkRs/Fir2C7EO3+R GGUPv+Mw==; 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 1v4J6J-002s7t-NL for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 13:12:11 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v4J6J-005hjU-07 for pgsql-bugs@lists.postgresql.org; Thu, 02 Oct 2025 13:12:03 +0000 Content-Type: multipart/mixed; boundary="===============5695584394705083710==" MIME-Version: 1.0 Subject: BUG #19069: pg_advisory_xact_lock() in a WITH query doesn't work To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: m.walczak@megavision.pl Reply-To: m.walczak@megavision.pl, pgsql-bugs@lists.postgresql.org Date: Thu, 02 Oct 2025 13:11:37 +0000 Message-ID: <19069-f5c72e4e4f921a7c@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 --===============5695584394705083710== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA2OQpMb2dnZWQgYnk6ICAgICAgICAgIE1hY2llaiBXYWxjemFrCkVt YWlsIGFkZHJlc3M6ICAgICAgbS53YWxjemFrQG1lZ2F2aXNpb24ucGwKUG9zdGdyZVNRTCB2ZXJz aW9uOiAxOC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMSBQcm8gMjRIMgpEZXNjcmlw dGlvbjogICAgICAgIAoKVGhpcyBkb2Vzbid0IGFjdHVhbGx5IGRvIGFueSBsb2NraW5nOgoKQkVH SU47CldJVEggbXlfbG9jayBBUyAoCiAgICAgICAgU0VMRUNUIHBnX2Fkdmlzb3J5X3hhY3RfbG9j aygxKQopCklOU0VSVCBJTlRPIG15X3RhYmxlICguLi4pIFZBTFVFUyAoLi4uKTsKQ09NTUlUOwoK VG8gcmVwcm9kdWNlIGp1c3QgcnVuIHRoaXMgY29kZSBpbiB0d28gc2Vzc2lvbnMgaW4gcGFyYWxs ZWwgd2l0aG91dApjb21taXRpbmcuCkJvdGggaW5zZXJ0cyB3aWxsIGltbWVkaWF0ZWx5IGNvbXBs ZXRlIHdpdGhvdXQgYmxvY2tpbmcuCgpJJ20gbm90IHN1cmUgaWYgdGhpcyBpcyBhIGJ1Zy4gSWYg aXQncyBub3QsIHBlcmhhcHMgdGhlIGRvY3VtZW50YXRpb24gc2hvdWxkCmJlIGNsYXJpZmllZC4K U2lkZS1lZmZlY3RzIG9mIFdJVEggcXVlcmllcyBhcmUgbWVudGlvbmVkIGhlcmUsIHNvIEkgd291 bGQgZXhwZWN0IG15IGNvZGUKdG8gd29yazoKaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xNi9xdWVyaWVzLXdpdGguaHRtbCNRVUVSSUVTLVdJVEgtQ1RFLU1BVEVSSUFMSVpBVElPTgoK VGVzdGVkIG9uIFBvc3RncmVzIDE4LjAgYW5kIDE2LjEwLgoK --===============5695584394705083710==--