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 1uhksm-003g2g-Ln for pgsql-committers@arkaria.postgresql.org; Fri, 01 Aug 2025 08:12: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 1uhksl-006USq-Mt for pgsql-committers@arkaria.postgresql.org; Fri, 01 Aug 2025 08:12:51 +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.94.2) (envelope-from ) id 1uhkrl-006SAo-If for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:49 +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 1uhkrh-000AON-18 for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=sRrj0sOo2pmNs7J1nDRvgwQnE8hbov082qEQmUqImec=; b=dwd6TZreAfotChZijBdpdP09PC WBsB8MTxssMz+RxCyIYJOIKukwC0ChPKDGUCd5e09HPN5nYTeBqy1DAKZ5q1VXcdoRPDCoakoddUh 9rqXD0yxb1cjUwOXiBJf7NUYFzDFyioA6qo5zWPPUKKnlkmJ2DTpaNaztxTHAD9BgwMNjZ282LfS6 u4xbf7gt2g8bl2C0UkXtTg358Ynf/5/NXkvphj0RS2f8BAMiUD9tOZgjUiFgpEbDfV/0frQ7DcZ+R NcIc9UY+k/yLwZFlxiYgRWYzlNlHyLiERcPL4xYZHq1CnE7RUfbwMClcjy/ynDA/epzN9dHqXfSZB KVqjHKZw==; 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 1uhkrf-000PI1-B1 for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:43 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uhkre-000A3w-1s for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:43 +0000 Content-Type: multipart/mixed; boundary="===============7776131917431540319==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 01 Aug 2025 08:11:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7776131917431540319== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGEgZGVhZGxvY2sgZHVyaW5nIEFMVEVSIFNVQlNDUklQVElPTiAuLi4gRFJPUCBQVUJMSUNB VElPTi4KCkEgZGVhZGxvY2sgY2FuIG9jY3VyIHdoZW4gdGhlIERETCBjb21tYW5kIGFuZCB0aGUg YXBwbHkgd29ya2VyIGFjcXVpcmUKY2F0YWxvZyBsb2NrcyBpbiBkaWZmZXJlbnQgb3JkZXJzIHdo aWxlIGRyb3BwaW5nIHJlcGxpY2F0aW9uIG9yaWdpbnMuCgpUaGUgaXNzdWUgaXMgcmFyZSBpbiBQ RzE2IGFuZCBoaWdoZXIgYnJhbmNoZXMgYmVjYXVzZSwgaW4gbW9zdCBjYXNlcywgdGhlCnRhYmxl c3luYyB3b3JrZXIgcGVyZm9ybXMgdGhlIG9yaWdpbiBkcm9wIGluIHRob3NlIGJyYW5jaGVzLCBh bmQgaXRzCmxvY2tpbmcgc2VxdWVuY2UgZG9lcyBub3QgY29uZmxpY3Qgd2l0aCBEREwgb3BlcmF0 aW9ucy4KClRoaXMgcGF0Y2ggZW5zdXJlcyBjb25zaXN0ZW50IGxvY2sgYWNxdWlzaXRpb24gdG8g cHJldmVudCBzdWNoIGRlYWRsb2Nrcy4KCkFzIHBlciBidWlsZGZhcm0uCgpSZXBvcnRlZC1ieTog QWxleGFuZGVyIExha2hpbiA8ZXhjbHVzaW9uQGdtYWlsLmNvbT4KQXV0aG9yOiBBamluIENoZXJp YW4gPGl0c2FqaW5AZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSGF5YXRvIEt1cm9kYSA8a3Vyb2Rh LmhheWF0b0BmdWppdHN1LmNvbT4KUmV2aWV3ZWQtYnk6IHZpZ25lc2ggQyA8dmlnbmVzaDIxQGdt YWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFtaXQgS2FwaWxhIDxhbWl0LmthcGlsYTE2QGdtYWlsLmNv bT4KQmFja3BhdGNoLXRocm91Z2g6IDE0LCB3aGVyZSBpdCB3YXMgaW50cm9kdWNlZApEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2JhYjk1ZTEyLTZjYzUtNGViYi04MGE4LTNlNDE5NTZh YTI5N0BnbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yYWIyZDZmOTcwNTg0YjdjYTYw Y2ZkZjY1NjkzMzY5MDNhYTg4ZGI1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9jYXRhbG9nL3BnX3N1YnNjcmlwdGlvbi5jICAgICAgIHwgMjEgKysrKysrKysrKysr KysrLS0tCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvdGFibGVzeW5jLmMgfCAzNCAr KysrKysrKysrKysrKysrKysrKysrKysrLS0tLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3N1YnNj cmlwdGlvbl9yZWwuaCAgIHwgIDIgKy0KMyBmaWxlcyBjaGFuZ2VkLCA0OSBpbnNlcnRpb25zKCsp LCA4IGRlbGV0aW9ucygtKQoK --===============7776131917431540319==--