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 1tEqnW-00A7h1-Iq for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Nov 2024 14:07:42 +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 1tEqnV-0015lI-8a for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Nov 2024 14:07:41 +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 1tEmw1-00HCnz-NO for pgsql-bugs@lists.postgresql.org; Sat, 23 Nov 2024 10: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 1tEmvu-003MEG-Px for pgsql-bugs@lists.postgresql.org; Sat, 23 Nov 2024 10: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=ZgHF9fBGj/KfCG6ILc+vZ8VRoc8J3H7KymR7Z3uAlgQ=; b=3+XjJYSyvzlnGEepfVG6JXK8Jk kDSpmExlXyJ/IvZ4356L6N6ncavQ/ymQBLeUA0xRDoIxnNC5EsWhs8+lAb0d4v03zE662nQtnmB6j b4puq2dDJiDTUZAC5LqU/bGxJ0INxcY5koYC9xoQp0blMi9oBrwNnzglRWwHMFxKOMdSU+Nd7xxMz ff0CTgGN2FD5wHQzxTsEWX/aiSa7QISnA5sjuYEhZbQA/+vUMrBWzt5yyqcDQPGMENEC1fbH+gk5v OgG7hGx/1//MSwlD21j2NI03AXtr9UM3EhqW55PvYYi9M7PO1AFLwgHVg/KsVFAF+pIsfSxoLYyk2 Mc/Q7Xhw==; 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 1tEmvu-00AR5i-34 for pgsql-bugs@lists.postgresql.org; Sat, 23 Nov 2024 10:00: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 1tEmvs-00EzPt-0O for pgsql-bugs@lists.postgresql.org; Sat, 23 Nov 2024 10:00:04 +0000 Content-Type: multipart/mixed; boundary="===============6038469939912742451==" MIME-Version: 1.0 Subject: BUG #18722: Processing arrays with plpgsql raises errors 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: Sat, 23 Nov 2024 10:00:01 +0000 Message-ID: <18722-fd9e645448cc78b4@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 --===============6038469939912742451== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODcyMgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTcuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpDUkVBVEUgRlVOQ1RJT04gbWFrZV9pYSgpIFJF VFVSTlMgaW50W10gTEFOR1VBR0UgcGxwZ3NxbCBBUw0KICAnZGVjbGFyZSB4IGludFtdOyBiZWdp biB4IDo9IGFycmF5WzBdOyByZXR1cm4geDsgZW5kJzsNCkNSRUFURSBGVU5DVElPTiBpYV9lcShp bnRbXSwgaW50W10pIFJFVFVSTlMgYm9vbGVhbiBMQU5HVUFHRSBwbHBnc3FsIEFTDQonYmVnaW4g cmV0dXJuIGFycmF5X2VxKCQxLCAkMik7IGVuZCc7IA0KQ1JFQVRFIE9QRVJBVE9SID0gKHByb2Nl ZHVyZSA9IGlhX2VxLCBsZWZ0YXJnID0gaW50W10sIHJpZ2h0YXJnID0gaW50W10pOw0KU0VMRUNU IE5VTExJRihtYWtlX2lhKCksIGFycmF5WzFdOjppbnRbXSk7DQoNCmZhaWxzIHdpdGg6DQpFUlJP UjogIGNhY2hlIGxvb2t1cCBmYWlsZWQgZm9yIHR5cGUgMjEzOTA2MjE0Mw0KDQpBbHNvLA0KU0VM RUNUIE5VTExJRihtYWtlX2lhKCksIGFycmF5WzFdOjppbnRbXSkgPSBOVUxMOw0KDQpmYWlscyB3 aXRoOg0KRVJST1I6ICBpbnZhbGlkIG1lbW9yeSBhbGxvYyByZXF1ZXN0IHNpemUgMTg0NDY3NDQw NzM2NDIxNzk1NzYNCg0KVGhlIGJhY2t0cmFjZSBvZiB0aGUgbGF0dGVyIGVycm9yIGlzOg0KLi4u DQojNiAgMHgwMDAwNTViNzVmZjBhOTZlIGluIE1lbW9yeUNvbnRleHRTaXplRmFpbHVyZSAoY29u dGV4dD0weDU1Yjc2MDc4N2Q3MCwKc2l6ZT0xODQ0Njc0NDA3MzY0MjE3OTU3NiwgZmxhZ3M9MCkg YXQgbWN4dC5jOjExNzANCiM3ICAweDAwMDA1NWI3NWZlZmI0ZWMgaW4gTWVtb3J5Q29udGV4dENo ZWNrU2l6ZSAoY29udGV4dD0weDU1Yjc2MDc4N2Q3MCwKc2l6ZT0xODQ0Njc0NDA3MzY0MjE3OTU3 NiwgZmxhZ3M9MCkgYXQKLi4vLi4vLi4vLi4vc3JjL2luY2x1ZGUvdXRpbHMvbWVtdXRpbHNfaW50 ZXJuYWwuaDoxNzINCiM4ICAweDAwMDA1NWI3NWZlZmMwODcgaW4gQWxsb2NTZXRBbGxvY0xhcmdl IChjb250ZXh0PTB4NTViNzYwNzg3ZDcwLApzaXplPTE4NDQ2NzQ0MDczNjQyMTc5NTc2LCBmbGFn cz0wKSBhdCBhc2V0LmM6NzA1DQojOSAgMHgwMDAwNTViNzVmZWZjNmMwIGluIEFsbG9jU2V0QWxs b2MgKGNvbnRleHQ9MHg1NWI3NjA3ODdkNzAsCnNpemU9MTg0NDY3NDQwNzM2NDIxNzk1NzYsIGZs YWdzPTApIGF0IGFzZXQuYzo5ODYNCiMxMCAweDAwMDA1NWI3NWZmMGFhNDAgaW4gTWVtb3J5Q29u dGV4dEFsbG9jIChjb250ZXh0PTB4NTViNzYwNzg3ZDcwLApzaXplPTE4NDQ2NzQ0MDczNjQyMTc5 NTc2KSBhdCBtY3h0LmM6MTIwMA0KIzExIDB4MDAwMDU1Yjc1ZmQwNGE2NCBpbiBjb3B5X2J5dmFs X2V4cGFuZGVkX2FycmF5IChlYWg9MHg1NWI3NjA3ODdlNzAsCm9sZGVhaD0weDU1Yjc2MDc4N2U3 MCkgYXQgYXJyYXlfZXhwYW5kZWQuYzoxOTcNCiMxMiAweDAwMDA1NWI3NWZkMDQ3ZDcgaW4gZXhw YW5kX2FycmF5IChhcnJheWRhdHVtPTk0MjQ2MDg1ODg1NTc2LApwYXJlbnRjb250ZXh0PTB4NTVi NzYwN2IwY2QwLCBtZXRhY2FjaGU9MHg3ZmZkNTQ4YzJjYzApIGF0CmFycmF5X2V4cGFuZGVkLmM6 MTA2DQojMTMgMHgwMDAwN2YwMDk0ZTU4ODhmIGluIHBscGdzcWxfZXhlY19mdW5jdGlvbiAoZnVu Yz0weDU1Yjc2MDZmMmZiMCwKZmNpbmZvPTB4NTViNzYwNzk5MmE4LCBzaW1wbGVfZXZhbF9lc3Rh dGU9MHgwLCBzaW1wbGVfZXZhbF9yZXNvd25lcj0weDAsCnByb2NlZHVyZV9yZXNvd25lcj0weDAs IGF0b21pYz10cnVlKSBhdCBwbF9leGVjLmM6NTY0DQojMTQgMHgwMDAwN2YwMDk0ZTc1NzI4IGlu IHBscGdzcWxfY2FsbF9oYW5kbGVyIChmY2luZm89MHg1NWI3NjA3OTkyYTgpIGF0CnBsX2hhbmRs ZXIuYzoyNzYNCiMxNSAweDAwMDA1NWI3NWY5ZGNkNDcgaW4gRXhlY0ludGVycEV4cHIgKHN0YXRl PTB4NTViNzYwNzk5MTUwLAplY29udGV4dD0weDU1Yjc2MDc5OGVmOCwgaXNudWxsPTB4N2ZmZDU0 OGMzMmRmKSBhdCBleGVjRXhwckludGVycC5jOjc0Ng0KLi4uDQoNCihnZGIpIGYgMTINCiMxMiAw eDAwMDA1NWI3NWZkMDQ3ZDcgaW4gZXhwYW5kX2FycmF5IChhcnJheWRhdHVtPTk0MjQ2MDg1ODg1 NTc2LApwYXJlbnRjb250ZXh0PTB4NTViNzYwN2IwY2QwLCBtZXRhY2FjaGU9MHg3ZmZkNTQ4YzJj YzApIGF0CmFycmF5X2V4cGFuZGVkLmM6MTA2DQoxMDYgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIGNvcHlfYnl2YWxfZXhwYW5kZWRfYXJyYXkoZWFoLCBvbGRlYWgpOw0KKGdkYikgcC94ICpv bGRlYWgNCiQxID0ge2hkciA9IHt2bF9sZW5fID0gMHhmZmZmZmZmZiwgZW9oX21ldGhvZHMgPSAw eDU1Yjc2MDJkOGY4MCwgZW9oX2NvbnRleHQKPSAweDU1Yjc2MDc4N2Q3MCwgZW9oX3J3X3B0ciA9 IHsweDEsIDB4MywgMHg3MCwgMHg3ZSwgMHg3OCwgMHg2MCwgMHhiNywKMHg1NSwgMHgwLCAweDB9 LCBlb2hfcm9fcHRyID0gezB4MSwgMHgyLCAweDcwLCAweDdlLCAweDc4LCAweDYwLCAweGI3LCAw eDU1LAoweDAsIA0KICAgICAgMHgwfX0sIGVhX21hZ2ljID0gMHgyOTE3MGE1OSwgbmRpbXMgPSAw eDdmN2Y3ZjdmLCBkaW1zID0KMHg3ZjdmN2Y3ZjdmN2Y3ZjdmLCBsYm91bmQgPSAweDdmN2Y3Zjdm N2Y3ZjdmN2YsIGVsZW1lbnRfdHlwZSA9IDB4N2Y3ZjdmN2YsCnR5cGxlbiA9IDB4N2Y3ZiwgdHlw Ynl2YWwgPSAweDdmLCB0eXBhbGlnbiA9IDB4N2YsIGR2YWx1ZXMgPQoweDdmN2Y3ZjdmN2Y3Zjdm N2YsIA0KICBkbnVsbHMgPSAweDdmN2Y3ZjdmN2Y3ZjdmN2YsIGR2YWx1ZXNsZW4gPSAweDdmN2Y3 ZjdmLCBuZWxlbXMgPSAweDdmN2Y3ZjdmLApmbGF0X3NpemUgPSAweDdmN2Y3ZjdmN2Y3ZjdmN2Ys IGZ2YWx1ZSA9IDB4N2Y3ZjdmN2Y3ZjdmN2Y3ZiwgZnN0YXJ0cHRyID0KMHg3ZjdmN2Y3ZjdmN2Y3 ZjdmLCBmZW5kcHRyID0gMHg3ZjdmN2Y3ZjdmN2Y3ZjdmfQ0KDQpJIGRpc2NvdmVyZWQgdGhpcyBp c3N1ZSB3aXRoIFNRTHNtaXRoLg0KUmVwcm9kdWNlZCBzdGFydGluZyBmcm9tIDFkYzVlYmM5MC4K Cg== --===============6038469939912742451==--