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 1uhksn-003g2e-2E 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-006USr-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-006SGV-Vv 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-000AOQ-17 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=5auCroJaHfIHAaQ5LetJhI+Czt5Q8GWWOXMsd67yVYk=; b=4Tf0stAzTFwHF7pK3A3j2rGnLW aOED8IlyVuhIGivcUTDpIy7Pne0Odce9riKXebj5zPGDqsEkt/rXK5MtAeyZ7VUIIZCoo/KgnaSa3 CFhh0yYQa76Gf2eCgatmFiJfx3YaaBj59HHtbWyjBJ96rgj8PA6aakDoqzQOUY/gbobRXF7kUnvyd kXoofrTj7VBXQUuDT4m20WmwXn5qdTvZ3vtn0621KtFq56xK9Yi/g9jlAtbn/5T4kn2uEU6p9mJCr 7CJ6wpkpV1oU64+CyZoSsadf7+dxQeUQqoCPp/pozmgFvFp8FPKp2VoXspKIHhWrDPPUyDWTBpSFX GlA9NOFg==; 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-000PI2-Aw 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-000A3y-20 for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:43 +0000 Content-Type: multipart/mixed; boundary="===============3232484197054137166==" 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 --===============3232484197054137166== 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 YTI5N0BnbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZDlmMDFhMjg3YWIx ZTAyNGY0MmVjMzA2NTAzNmYyNGRjNzIwNjZhZgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19zdWJzY3JpcHRpb24uYyAgICAgICB8IDIxICsrKysr KysrKysrKysrKy0tLQpzcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3RhYmxlc3luYy5j IHwgMzQgKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9w Z19zdWJzY3JpcHRpb25fcmVsLmggICB8ICAyICstCjMgZmlsZXMgY2hhbmdlZCwgNDkgaW5zZXJ0 aW9ucygrKSwgOCBkZWxldGlvbnMoLSkKCg== --===============3232484197054137166==--