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 1rSe2d-00F0BW-Lu for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Jan 2024 14:15:48 +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 1rSe2c-005N4Q-SO for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Jan 2024 14:15:46 +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 1rSbvR-004NZr-DJ for pgsql-bugs@lists.postgresql.org; Wed, 24 Jan 2024 12:00:13 +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.94.2) (envelope-from ) id 1rSbvK-0037aE-7q for pgsql-bugs@lists.postgresql.org; Wed, 24 Jan 2024 12:00:12 +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=y+HQODxCe+ls3L5tOlJ47HjVRS119roBRTwVmluQmlo=; b=6InfkHyLKPDfPb+BkI6apC0J+H /uc4Pobt2KGUcgcMet0qO0I1M3IW4mb7Zt3WYBTYMPt9U3isGFzzMk8tPLmQCsyHnilzlzWBRXV5m KLRdA9GPpkfuASQ3zTL8ldUV0yW0BI5v8hCRpBE0ipOaQ6YSTBXYw91LiVZaRwX+2r3Zz5Lddh3mf KPljem/LUR4mrdQTm083h/+FGJbfx9Ej6+a4BqgKLTlPD/IakhKDx1csx5DS01Bk9ozwJGkQfiJGI c+uBJ0HTqvQAxFHLD9izLQYNVTh9hz4CJeVu2xou2qRKOnT1F3K9FEdj2ATRiopL2LhmdrPm1XJiM vhK704PA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSbvJ-009UNz-Fd for pgsql-bugs@lists.postgresql.org; Wed, 24 Jan 2024 12:00:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rSbvH-004fu9-Ta for pgsql-bugs@lists.postgresql.org; Wed, 24 Jan 2024 12:00:04 +0000 Content-Type: multipart/mixed; boundary="===============8017705314624308486==" MIME-Version: 1.0 Subject: BUG #18309: TOASTed entry in pg_subscription provokes an assertion failure To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 24 Jan 2024 12:00:01 +0000 Message-ID: <18309-c0bf914950c46692@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 --===============8017705314624308486== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODMwOQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTYuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiBhIHBnX3N1YnNjcmlwdGlvbiBlbnRyeSBjb250YWlucyBhIFRPQVNUZWQgZmll bGQsIGUuZy4sIHN1YmNvbm5pbmZvLA0Kc2V2ZXJhbCBvcGVyYXRpb25zIHdpdGggdGhlIHN1YnNj cmlwdGlvbiB0cmlnZ2VyIGFuIGFzc2VydGlvbiBmYWlsdXJlLg0KDQpGb3IgZXhhbXBsZSwgd2l0 aCB0aGUgZm9sbG93aW5nIG1vZGlmaWNhdGlvbiBvZiB0ZXN0IDAyOV9vbl9lcnJvci5wbDoNCi1t eSAkcHVibGlzaGVyX2Nvbm5zdHIgPSAkbm9kZV9wdWJsaXNoZXItPmNvbm5zdHIgLiAnIGRibmFt ZT1wb3N0Z3Jlcyc7DQorbXkgJHB1Ymxpc2hlcl9jb25uc3RyID0gJG5vZGVfcHVibGlzaGVyLT5j b25uc3RyIC4gJyBkYm5hbWU9cG9zdGdyZXMKcGFzc3dvcmQ9JyAuIGpvaW4oJycsIG1hcCB7Y2hy KDY1ICsgcmFuZCAyNil9ICgxIC4uIDEwMDAwKSk7DQoNCkkgZ2V0IGFuIGFzc2VydGlvbiBmYWls dXJlIHdpdGggdGhlIHN0YWNrOg0KLi4uDQojNSAgMHgwMDAwNTU2ZDdjOWQxY2Q3IGluIEV4Y2Vw dGlvbmFsQ29uZGl0aW9uCihjb25kaXRpb25OYW1lPWNvbmRpdGlvbk5hbWVAZW50cnk9MHg1NTZk N2NhMzU2ZTAKIkhhdmVSZWdpc3RlcmVkT3JBY3RpdmVTbmFwc2hvdCgpIiwgZmlsZU5hbWU9Zmls ZU5hbWVAZW50cnk9MHg1NTZkN2NhMzUzZTYKInRvYXN0X2ludGVybmFscy5jIiwgbGluZU51bWJl cj1saW5lTnVtYmVyQGVudHJ5PTY3MCkNCiAgICBhdCBhc3NlcnQuYzo2Ng0KIzYgIDB4MDAwMDU1 NmQ3YzQ4ODI3ZCBpbiBpbml0X3RvYXN0X3NuYXBzaG90ICguLi4pIGF0CnRvYXN0X2ludGVybmFs cy5jOjY3MA0KIzcgIDB4MDAwMDU1NmQ3YzQ4ODMzMSBpbiB0b2FzdF9kZWxldGVfZGF0dW0gKC4u LikgYXQKdG9hc3RfaW50ZXJuYWxzLmM6NDI5DQojOCAgMHgwMDAwNTU2ZDdjNTI4M2ZhIGluIHRv YXN0X3R1cGxlX2NsZWFudXAgKC4uLikgYXQgdG9hc3RfaGVscGVyLmM6MzA5DQojOSAgMHgwMDAw NTU2ZDdjNGUwNmM0IGluIGhlYXBfdG9hc3RfaW5zZXJ0X29yX3VwZGF0ZSAoLi4uKSBhdApoZWFw dG9hc3QuYzozMzMNCiMxMCAweDAwMDA1NTZkN2M0ZDNhOGEgaW4gaGVhcF91cGRhdGUgKC4uLikg YXQgaGVhcGFtLmM6MzYxMw0KIzExIDB4MDAwMDU1NmQ3YzRkNDRlOSBpbiBzaW1wbGVfaGVhcF91 cGRhdGUgKC4uLikgYXQgaGVhcGFtLmM6NDA3MQ0KIzEyIDB4MDAwMDU1NmQ3YzU3YzBhOCBpbiBD YXRhbG9nVHVwbGVVcGRhdGUgKC4uLikgYXQgaW5kZXhpbmcuYzozMjINCiMxMyAweDAwMDA1NTZk N2M1OWQ0YTUgaW4gRGlzYWJsZVN1YnNjcmlwdGlvbiAoLi4uKSBhdApwZ19zdWJzY3JpcHRpb24u YzoxOTYNCiMxNCAweDAwMDA1NTZkN2M4MTJjNzYgaW4gRGlzYWJsZVN1YnNjcmlwdGlvbkFuZEV4 aXQgKCkgYXQgd29ya2VyLmM6NDc0OA0KIzE1IDB4MDAwMDU1NmQ3YzgxMmUxYyBpbiBzdGFydF90 YWJsZV9zeW5jICguLi4pIGF0IHdvcmtlci5jOjQzODYNCiMxNiAweDAwMDA1NTZkN2M4MTgxNzYg aW4gQXBwbHlXb3JrZXJNYWluICguLi4pIGF0IHdvcmtlci5jOjQ1NjQNCiMxNyAweDAwMDA1NTZk N2M3ZGE3ZmEgaW4gU3RhcnRCYWNrZ3JvdW5kV29ya2VyICgpIGF0IGJnd29ya2VyLmM6ODYxDQou Li4NCg0KQWZ0ZXIgdGhpcyBmYWlsdXJlIGVsaW1pbmF0aW9uICh3aXRoIFB1c2hBY3RpdmVTbmFw c2hvdCgpLw0KUG9wQWN0aXZlU25hcHNob3QoKSBpbnNpZGUgRGlzYWJsZVN1YnNjcmlwdGlvbkFu ZEV4aXQoKSksIHRoZSBzYW1lIHRlc3QNCnByb2R1Y2VzIGFub3RoZXIgb25lOg0KLi4uDQojNSAg MHgwMDAwNTU1YTIwM2YxY2U5IGluIEV4Y2VwdGlvbmFsQ29uZGl0aW9uCihjb25kaXRpb25OYW1l PWNvbmRpdGlvbk5hbWVAZW50cnk9MHg1NTVhMjA0NTU2ZTAKIkhhdmVSZWdpc3RlcmVkT3JBY3Rp dmVTbmFwc2hvdCgpIiwgZmlsZU5hbWU9ZmlsZU5hbWVAZW50cnk9MHg1NTVhMjA0NTUzZTYKInRv YXN0X2ludGVybmFscy5jIiwgbGluZU51bWJlcj1saW5lTnVtYmVyQGVudHJ5PTY3MCkNCiAgICBh dCBhc3NlcnQuYzo2Ng0KIzYgIDB4MDAwMDU1NWExZmVhODI3ZCBpbiBpbml0X3RvYXN0X3NuYXBz aG90ICguLi4pIGF0CnRvYXN0X2ludGVybmFscy5jOjY3MA0KIzcgIDB4MDAwMDU1NWExZmVhODMz MSBpbiB0b2FzdF9kZWxldGVfZGF0dW0gKC4uLikgYXQKdG9hc3RfaW50ZXJuYWxzLmM6NDI5DQoj OCAgMHgwMDAwNTU1YTFmZjQ4M2ZhIGluIHRvYXN0X3R1cGxlX2NsZWFudXAgKC4uLikgYXQgdG9h c3RfaGVscGVyLmM6MzA5DQojOSAgMHgwMDAwNTU1YTFmZjAwNmM0IGluIGhlYXBfdG9hc3RfaW5z ZXJ0X29yX3VwZGF0ZSAoLi4uKSBhdApoZWFwdG9hc3QuYzozMzMNCiMxMCAweDAwMDA1NTVhMWZl ZjNhOGEgaW4gaGVhcF91cGRhdGUgKC4uLikgYXQgaGVhcGFtLmM6MzYxMw0KIzExIDB4MDAwMDU1 NWExZmVmNDRlOSBpbiBzaW1wbGVfaGVhcF91cGRhdGUgKC4uLikgYXQgaGVhcGFtLmM6NDA3MQ0K IzEyIDB4MDAwMDU1NWExZmY5YzBhOCBpbiBDYXRhbG9nVHVwbGVVcGRhdGUgKC4uLikgYXQgaW5k ZXhpbmcuYzozMjINCiMxMyAweDAwMDA1NTVhMjAyMzEzMzEgaW4gVXBkYXRlVHdvUGhhc2VTdGF0 ZSAoLi4uKSBhdCB0YWJsZXN5bmMuYzoxNjY5DQojMTQgMHgwMDAwNTU1YTIwMjM4M2QzIGluIEFw cGx5V29ya2VyTWFpbiAoLi4uKSBhdCB3b3JrZXIuYzo0Njk0DQojMTUgMHgwMDAwNTU1YTIwMWZh N2ZhIGluIFN0YXJ0QmFja2dyb3VuZFdvcmtlciAoKSBhdCBiZ3dvcmtlci5jOjg2MQ0KLi4uDQoN CkFmdGVyIHRoaXMgZmFpbHVyZSBlbGltaW5hdGlvbiAod2l0aCBQdXNoQWN0aXZlU25hcHNob3Qo KS8NClBvcEFjdGl2ZVNuYXBzaG90KCkgaW5zaWRlIEFwcGx5V29ya2VyTWFpbigpKSwgdGhlIHNh bWUgdGVzdCBwcm9kdWNlcw0KYW5vdGhlciBvbmU6DQouLi4NCiM1ICAweDAwMDA1NTY3MTgzYTVj ZmYgaW4gRXhjZXB0aW9uYWxDb25kaXRpb24KKGNvbmRpdGlvbk5hbWU9Y29uZGl0aW9uTmFtZUBl bnRyeT0weDU1NjcxODQwOTZlMAoiSGF2ZVJlZ2lzdGVyZWRPckFjdGl2ZVNuYXBzaG90KCkiLCBm aWxlTmFtZT1maWxlTmFtZUBlbnRyeT0weDU1NjcxODQwOTNlNgoidG9hc3RfaW50ZXJuYWxzLmMi LCBsaW5lTnVtYmVyPWxpbmVOdW1iZXJAZW50cnk9NjcwKQ0KICAgIGF0IGFzc2VydC5jOjY2DQoj NiAgMHgwMDAwNTU2NzE3ZTVjMjdkIGluIGluaXRfdG9hc3Rfc25hcHNob3QgKC4uLikgYXQKdG9h c3RfaW50ZXJuYWxzLmM6NjcwDQojNyAgMHgwMDAwNTU2NzE3ZTVjMzMxIGluIHRvYXN0X2RlbGV0 ZV9kYXR1bSAoLi4uKSBhdAp0b2FzdF9pbnRlcm5hbHMuYzo0MjkNCiM4ICAweDAwMDA1NTY3MTdl ZmMzZmEgaW4gdG9hc3RfdHVwbGVfY2xlYW51cCAoLi4uKSBhdCB0b2FzdF9oZWxwZXIuYzozMDkN CiM5ICAweDAwMDA1NTY3MTdlYjQ2YzQgaW4gaGVhcF90b2FzdF9pbnNlcnRfb3JfdXBkYXRlICgu Li4pIGF0CmhlYXB0b2FzdC5jOjMzMw0KIzEwIDB4MDAwMDU1NjcxN2VhN2E4YSBpbiBoZWFwX3Vw ZGF0ZSAoLi4uKSBhdCBoZWFwYW0uYzozNjEzDQojMTEgMHgwMDAwNTU2NzE3ZWE4NGU5IGluIHNp bXBsZV9oZWFwX3VwZGF0ZSAoLi4uKSBhdCBoZWFwYW0uYzo0MDcxDQojMTIgMHgwMDAwNTU2NzE3 ZjUwMGE4IGluIENhdGFsb2dUdXBsZVVwZGF0ZSAoLi4uKSBhdCBpbmRleGluZy5jOjMyMg0KIzEz IDB4MDAwMDU1NjcxODFlNzQ1MSBpbiBjbGVhcl9zdWJzY3JpcHRpb25fc2tpcF9sc24gKC4uLikg YXQKd29ya2VyLmM6MjI3NA0KIzE1IDB4MDAwMDU1NjcxODFlYTIwZSBpbiBhcHBseV9oYW5kbGVf Y29tbWl0ICguLi4pIGF0IHdvcmtlci5jOjEwNDANCiMxNiAweDAwMDA1NTY3MTgxZWFjZmYgaW4g YXBwbHlfZGlzcGF0Y2ggKC4uLikgYXQgd29ya2VyLmM6MzMwNQ0KIzE3IDB4MDAwMDU1NjcxODFl YjY0MyBpbiBMb2dpY2FsUmVwQXBwbHlMb29wICguLi4pIGF0IHdvcmtlci5jOjM2MDMNCiMxOCAw eDAwMDA1NTY3MTgxZWJhNzIgaW4gc3RhcnRfYXBwbHkgKC4uLikgYXQgd29ya2VyLmM6NDQxOQ0K IzE5IDB4MDAwMDU1NjcxODFlYzQ2OSBpbiBBcHBseVdvcmtlck1haW4gKC4uLikgYXQgd29ya2Vy LmM6NDcyMA0KIzIwIDB4MDAwMDU1NjcxODFhZTdmYSBpbiBTdGFydEJhY2tncm91bmRXb3JrZXIg KCkgYXQgYmd3b3JrZXIuYzo4NjENCi4uLg0KDQpGaW5hbGx5LCBhZnRlciB0aGlzIGZhaWx1cmUg ZWxpbWluYXRpb24gKHdpdGggUHVzaEFjdGl2ZVNuYXBzaG90KCkvDQpQb3BBY3RpdmVTbmFwc2hv dCgpIGluc2lkZSBjbGVhcl9zdWJzY3JpcHRpb25fc2tpcF9sc24oKSksIHRoaXMgdGVzdA0KcGFz c2VzLgoK --===============8017705314624308486==--