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 1tBrqJ-006cbo-NC for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Nov 2024 08:38:15 +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 1tBrqH-008LrP-4k for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Nov 2024 08:38:13 +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 1tBmQS-007XwQ-T6 for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2024 02:51:13 +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.94.2) (envelope-from ) id 1tBmQM-00206Y-7m for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2024 02:51: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=+T6C+49u77A/IqSmHYlHeXuwLpsNdTXMOY57yy+D6sg=; b=oIPpnAAFG7xAj8mAEzYMah/lLb IX7ZwfZyPtFxRUp7GhRY8mMpdBNTx6j9ar/BILoP+THITeV9D/W3HtmzDGZnch4P/85f0cfIQwzTJ c1ol7sw8rm9xpKQN280HIfhMDdaoYDa+30kgdg+zLuhkDEVsQ6ZVQ0Tkbw3jAnLfUlpv2tK+pGvtW px9lRVjBSRwCLGLTtKbWS8jUPrebaxPvJO+1fm2yz3w+e7LclhIFnZBaSHVsErRmVHf/Y1CfB55SM ILtLy72qXPy+vTr8t9RpfbM1d//8mN0cIHmOyXXhQS5/fB1mfyne9Ofsabldzdm7psrOW3CiQE0Cp qS9ZiyMQ==; 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 1tBmQJ-0066qT-Rd for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2024 02:51:06 +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 1tBmQH-008j8z-TG for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2024 02:51:02 +0000 Content-Type: multipart/mixed; boundary="===============0344780653970089829==" MIME-Version: 1.0 Subject: BUG #18710: "pg_get_viewdef" triggers assertions in special scenarios To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zengman@halodbtech.com Reply-To: zengman@halodbtech.com, pgsql-bugs@lists.postgresql.org Date: Fri, 15 Nov 2024 02:50:47 +0000 Message-ID: <18710-ceab935c95da55aa@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 --===============0344780653970089829== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODcxMApMb2dnZWQgYnk6ICAgICAgICAgIE1hbiBaZW5nCkVtYWlsIGFk ZHJlc3M6ICAgICAgemVuZ21hbkBoYWxvZGJ0ZWNoLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE0 LjE0Ck9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zLTgKRGVzY3JpcHRpb246ICAgICAgICAKCkEg cHJvdG90eXBlIG9mIHRoZSBwcm9ibGVtIGZyb20KaHR0cHM6Ly9naXRodWIuY29tL2R1Y2tkYi9w Z19kdWNrZGIvaXNzdWVzLzQzNQ0KVGhpcyBleGNlcHRpb24gY2FuIGJlIHJlbGlhYmx5IHRyaWdn ZXJlZCBieSBjYWxsaW5nICJwZ19nZXRfdmlld2RlZiINCg0KU3RlcCAxIO+8mg0KQ1JFQVRFIFZJ RVcgdmlld19hIEFTIA0KV0lUSCBSRUNVUlNJVkUgb3V0ZXJtb3N0KHgpIEFTICgNCiBTRUxFQ1Qg MQ0KIFVOSU9OIChXSVRIIGlubmVybW9zdDEgQVMgKA0KIFNFTEVDVCAyKQ0KICBTRUxFQ1QgKiBG Uk9NIG91dGVybW9zdA0KICBVTklPTiBTRUxFQ1QgKiBGUk9NIGlubmVybW9zdDEpDQogKQ0KIFNF TEVDVCAqIEZST00gb3V0ZXJtb3N0IE9SREVSIEJZIDE7DQoNClN0ZXAgMiDvvJoNClNFTEVDVCBv aWQgRlJPTSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lID0gJ3ZpZXdfYSc7DQoNClN0ZXAgM++8mg0K U0VMRUNUIHBnX2dldF92aWV3ZGVmKCB0aGlzIG9pZCApOyAtLSBlcnJvcg0KDQpUaGUgYWJub3Jt YWxpdGllcyBhcHBlYXIgYXMgZm9sbG93cw0KW3Bvc3RncmVzQGladWY2aHdvMHdnZWV2NGR2dWE0 Y3NaIHBvc3RncmVzXSQgcHNxbA0KcHNxbCAoMTQuMTQpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4N Cg0KcG9zdGdyZXM9IyBDUkVBVEUgVklFVyB2aWV3X2EgQVMgDQpwb3N0Z3Jlcy0jIFdJVEggUkVD VVJTSVZFIG91dGVybW9zdCh4KSBBUyAoDQpwb3N0Z3JlcygjICBTRUxFQ1QgMQ0KcG9zdGdyZXMo IyAgVU5JT04gKFdJVEggaW5uZXJtb3N0MSBBUyAoDQpwb3N0Z3JlcygjICBTRUxFQ1QgMikNCnBv c3RncmVzKCMgICBTRUxFQ1QgKiBGUk9NIG91dGVybW9zdA0KcG9zdGdyZXMoIyAgIFVOSU9OIFNF TEVDVCAqIEZST00gaW5uZXJtb3N0MSkNCnBvc3RncmVzKCMgICkNCnBvc3RncmVzLSMgIFNFTEVD VCAqIEZST00gb3V0ZXJtb3N0IE9SREVSIEJZIDE7DQpDUkVBVEUgVklFVw0KcG9zdGdyZXM9IyBT RUxFQ1QgKiBGUk9NIHBnX2NsYXNzIHdoZXJlIHJlbG5hbWUgPSAndmlld19hJzsNCiAgb2lkICB8 IHJlbG5hbWUgfCByZWxuYW1lc3BhY2UgfCByZWx0eXBlIHwgcmVsb2Z0eXBlIHwgcmVsb3duZXIg fCByZWxhbSB8CnJlbGZpbGVub2RlIHwgcmVsdGFibGVzcGFjZSB8IHJlbHBhZ2VzIHwgcmVsdHVw bGVzIHwgcmVsYWxsdmlzaWJsZSB8CnJlbHRvYXN0cmVsaWQgfCByZWxoYXNpbmRleCB8IHJlbGlz c2hhcmVkIHwgcmVscGVyc2lzdGVuY2UgfCByZWxraW5kIHwKcmVsbmF0dA0KcyB8IHJlbGNoZWNr cyB8IHJlbGhhc3J1bGVzIHwgcmVsaGFzdHJpZ2dlcnMgfCByZWxoYXNzdWJjbGFzcyB8CnJlbHJv d3NlY3VyaXR5IHwgcmVsZm9yY2Vyb3dzZWN1cml0eSB8IHJlbGlzcG9wdWxhdGVkIHwgcmVscmVw bGlkZW50IHwKcmVsaXNwYXJ0aXRpb24gfCByZWxyZXdyaXRlIHwgcmVsZnJvemVueGlkIHwgcmVs bWlubXhpZCB8IHJlbGFjbCB8CnJlbG9wdGlvbnMgfCByZWxwYXJ0DQpib3VuZCANCi0tLS0tLS0r LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0t Ky0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0t LS0tLSstLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLQ0KLS0rLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tDQotLS0tLS0NCiAzMjc2OCB8 IHZpZXdfYSAgfCAgICAgICAgIDIyMDAgfCAgIDMyNzcwIHwgICAgICAgICAwIHwgICAgICAgMTAg fCAgICAgMCB8ICAKICAgICAgICAwIHwgICAgICAgICAgICAgMCB8ICAgICAgICAwIHwgICAgICAg IC0xIHwgICAgICAgICAgICAgMCB8ICAgICAgICAgIAogIDAgfCBmICAgICAgICAgICB8IGYgICAg ICAgICAgIHwgcCAgICAgICAgICAgICAgfCB2ICAgICAgIHwgICAgICAgIA0KMSB8ICAgICAgICAg MCB8IHQgICAgICAgICAgIHwgZiAgICAgICAgICAgICAgfCBmICAgICAgICAgICAgICB8IGYgICAg ICAgICAgIAogIHwgZiAgICAgICAgICAgICAgICAgICB8IHQgICAgICAgICAgICAgIHwgbiAgICAg ICAgICAgIHwgZiAgICAgICAgICAgICAgfCAgCiAgICAgICAwIHwgICAgICAgICAgICAwIHwgICAg ICAgICAgMCB8ICAgICAgICB8ICAgICAgICAgICAgfCANCigxIHJvdykNCg0KcG9zdGdyZXM9IyBz ZWxlY3QgcGdfZ2V0X3ZpZXdkZWYoMzI3NjgpOw0KVFJBUDogRmFpbGVkQXNzZXJ0aW9uKCJzdWJx dWVyeS0+c2V0T3BlcmF0aW9ucyA9PSBOVUxMIiwgRmlsZToKInJ1bGV1dGlscy5jIiwgTGluZTog NjA5NCwgUElEOiAzMjU5NDgpDQpwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2FsXQpT RUxFQ1QoRXhjZXB0aW9uYWxDb25kaXRpb24rMHhiOSlbMHhiMWE2YzFdDQpwb3N0Z3JlczogcG9z dGdyZXMgcG9zdGdyZXMgW2xvY2FsXSBTRUxFQ1RbMHhhOTVkNmJdDQpwb3N0Z3JlczogcG9zdGdy ZXMgcG9zdGdyZXMgW2xvY2FsXSBTRUxFQ1RbMHhhOTYwYjVdDQouLi4uLi4NCg0KTWF5YmUgd2Ug Y2FuIGNvbW1lbnQgb3V0IHRoZSBhc3NlcnRpb24gdGhhdCByYWlzZXMgdGhlIGV4Y2VwdGlvbiwg YmVjYXVzZSBJCmxvb2tlZCB1cCB0aGUgY29kZSBhbmQgZm91bmQgdGhhdCB0aGUgYXNzZXJ0aW9u IGRvZXNuJ3Qgc2VlbSB0byBtYWtlIGEgbG90Cm9mIHNlbnNlIGhlcmUuDQpJIGxvb2sgZm9yd2Fy ZCB0byB5b3VyIGRpc2N1c3Npb24uCgo= --===============0344780653970089829==--