Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gAtJk-0007JQ-Et for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Oct 2018 09:01:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gAtJi-0001Gl-Mi for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Oct 2018 09:01:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gAtJi-0001Ge-Gc for pgsql-bugs@lists.postgresql.org; Fri, 12 Oct 2018 09:01:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gAtJf-00084O-Tf for pgsql-bugs@lists.postgresql.org; Fri, 12 Oct 2018 09:01:06 +0000 Content-Type: multipart/mixed; boundary="===============3160000082019537328==" MIME-Version: 1.0 Subject: BUG #15428: "Inception" with recursive prepared statement causes infinite loop To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: mborch@gmail.com Reply-To: mborch@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 12 Oct 2018 09:00:12 +0000 Message-ID: <15428-b3c2915ec470b033@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3160000082019537328== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTQyOApMb2dnZWQgYnk6ICAgICAgICAgIE1hbHRoZSBCb3JjaApFbWFp bCBhZGRyZXNzOiAgICAgIG1ib3JjaEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMWJl dGE0Ck9wZXJhdGluZyBzeXN0ZW06ICAgTWFjT1MKRGVzY3JpcHRpb246ICAgICAgICAKClVzaW5n IHRoZSBleHRlbmRlZCBxdWVyeSBtZXNzYWdlIGZsb3csIEkgcHJlcGFyZSwgYmluZCBhbmQgZXhl Y3V0ZSBhIHF1ZXJ5CmFzIGEgbmFtZWQgc3RhdGVtZW50Lg0KDQpJZiBJIHJlcGVhdCB0aGlzIGFn YWluIHdpdGggdGhlIHF1ZXJ5ICJleGVjdXRlIDxuYW1lPiIg4oCTIHRoZSBiYWNrZW5kIGNyYXNo ZXMKd2l0aCBhIHNlZ21lbnRhdGlvbiBmYXVsdCBkdWUgdG8gYW4gaW5maW5pdGUgcmVjdXJzaW9u IChzZWUgZXhjZXJwdApiZWxvdykuDQoNCldoaWxlIGl0IGRvZXNuJ3QgcmVhbGx5IG1ha2Ugc2Vu c2UgdG8gcHJlcGFyZSBhIHN0YXRlbWVudCB0aGF0IGV4ZWN1dGVzIGEKc3RhdGVtZW50LCB0aGVy ZSBzdGlsbCBzZWVtcyB0byBiZSBhIHJlYWwgaXNzdWUgaGVyZS4gSXQgZG9lc24ndCBzZWVtIHRv Cm1ha2UgYSBkaWZmZXJlbmNlIHVzaW5nIHRoZSB1bm5hbWVkIHBvcnRhbCBvciBhIHVuaXF1ZSBu YW1lIHBlciBzdGF0ZW1lbnQuDQoNCi0tLS0NCg0KKiB0aHJlYWQgIzEsIHF1ZXVlID0gJ2NvbS5h cHBsZS5tYWluLXRocmVhZCcsIHN0b3AgcmVhc29uID0gRVhDX0JBRF9BQ0NFU1MKKGNvZGU9Miwg YWRkcmVzcz0weDdmZmVlZjNmZmZhOCkNCiAgKiBmcmFtZSAjMDogMHgwMDAwMDAwMTAwNzNiNDlh IHBvc3RncmVzYGRvcHIodGFyZ2V0PTx1bmF2YWlsYWJsZT4sCmZvcm1hdD08dW5hdmFpbGFibGU+ LCBhcmdzPTx1bmF2YWlsYWJsZT4pIGF0IHNucHJpbnRmLmM6Mzc3DQogICAgZnJhbWUgIzE6IDB4 MDAwMDAwMDEwMDczYzg0ZiBwb3N0Z3Jlc2BwZ192c3ByaW50ZihzdHI9IjBceDA0QD8/IiwKZm10 PSI8dW5uYW1lZCBwb3J0YWwgJXU+IiwgYXJncz0weDAwMDA3ZmZlZWY0MDAzYzApIGF0IHNucHJp bnRmLmM6MjIzDQogICAgZnJhbWUgIzI6IDB4MDAwMDAwMDEwMDczY2EwYyBwb3N0Z3Jlc2BwZ19z cHJpbnRmKHN0cj0iMFx4MDRAPz8iLApmbXQ9Ijx1bm5hbWVkIHBvcnRhbCAldT4iKSBhdCBzbnBy aW50Zi5jOjIzNg0KICAgIGZyYW1lICMzOiAweDAwMDAwMDAxMDA3MGQ4NDIgcG9zdGdyZXNgQ3Jl YXRlTmV3UG9ydGFsIGF0CnBvcnRhbG1lbS5jOjI0NA0KICAgIGZyYW1lICM0OiAweDAwMDAwMDAx MDAyNWEzZjIKcG9zdGdyZXNgRXhlY3V0ZVF1ZXJ5KHN0bXQ9MHgwMDAwMDAwMTAyMDBhYTQ4LApp bnRvQ2xhdXNlPTB4MDAwMDAwMDAwMDAwMDAwMCwgcXVlcnlTdHJpbmc9ImV4ZWN1dGUgdGVzdCgk MSkiLApwYXJhbXM9MHgwMDAwMDAwMDAwMDAwMDAwLCBkZXN0PTB4MDAwMDAwMDEwMDkzZGEwOCwg Y29tcGxldGlvblRhZz0iIikgYXQKcHJlcGFyZS5jOjIzNw0KICAgIGZyYW1lICM1OiAweDAwMDAw MDAxMDA1MTI5MjQKcG9zdGdyZXNgc3RhbmRhcmRfUHJvY2Vzc1V0aWxpdHkocHN0bXQ9MHgwMDAw MDAwMTAyMDBhOWIwLApxdWVyeVN0cmluZz0iZXhlY3V0ZSB0ZXN0KCQxKSIsIGNvbnRleHQ9UFJP Q0VTU19VVElMSVRZX1FVRVJZLApwYXJhbXM9MHgwMDAwMDAwMDAwMDAwMDAwLCBxdWVyeUVudj0w eDAwMDAwMDAwMDAwMDAwMDAsCmRlc3Q9MHgwMDAwMDAwMTAwOTNkYTA4LCBjb21wbGV0aW9uVGFn PSIiKSBhdCB1dGlsaXR5LmM6NTY0DQogICAgZnJhbWUgIzY6IDB4MDAwMDAwMDEwMDUxMjNhNQpw b3N0Z3Jlc2BQcm9jZXNzVXRpbGl0eShwc3RtdD0weDAwMDAwMDAxMDIwMGE5YjAsIHF1ZXJ5U3Ry aW5nPSJleGVjdXRlCnRlc3QoJDEpIiwgY29udGV4dD1QUk9DRVNTX1VUSUxJVFlfUVVFUlksIHBh cmFtcz0weDAwMDAwMDAwMDAwMDAwMDAsCnF1ZXJ5RW52PTB4MDAwMDAwMDAwMDAwMDAwMCwgZGVz dD0weDAwMDAwMDAxMDA5M2RhMDgsIGNvbXBsZXRpb25UYWc9IiIpIGF0CnV0aWxpdHkuYzozNjAN CiAgICBmcmFtZSAjNzogMHgwMDAwMDAwMTAwNTExZDg3CnBvc3RncmVzYFBvcnRhbFJ1blV0aWxp dHkocG9ydGFsPTB4MDAwMDAwMDEwZTkxMmM4OCwKcHN0bXQ9MHgwMDAwMDAwMTAyMDBhOWIwLCBp c1RvcExldmVsPTx1bmF2YWlsYWJsZT4sCnNldEhvbGRTbmFwc2hvdD08dW5hdmFpbGFibGU+LCBk ZXN0PTx1bmF2YWlsYWJsZT4sIGNvbXBsZXRpb25UYWc9IiIpIGF0CnBxdWVyeS5jOjExNzgNCiAg ICBmcmFtZSAjODogMHgwMDAwMDAwMTAwNTExNGU0CnBvc3RncmVzYFBvcnRhbFJ1bk11bHRpKHBv cnRhbD0weDAwMDAwMDAxMGU5MTJjODgsIGlzVG9wTGV2ZWw9ZmFsc2UsCnNldEhvbGRTbmFwc2hv dD1mYWxzZSwgZGVzdD0weDAwMDAwMDAxMDA5M2RhMDgsIGFsdGRlc3Q9MHgwMDAwMDAwMTAwOTNk YTA4LApjb21wbGV0aW9uVGFnPSIiKSBhdCBwcXVlcnkuYzowDQogICAgZnJhbWUgIzk6IDB4MDAw MDAwMDEwMDUxMGQ0ZQpwb3N0Z3Jlc2BQb3J0YWxSdW4ocG9ydGFsPTB4MDAwMDAwMDEwZTkxMmM4 OCwgY291bnQ9OTIyMzM3MjAzNjg1NDc3NTgwNywKaXNUb3BMZXZlbD1mYWxzZSwgcnVuX29uY2U9 PHVuYXZhaWxhYmxlPiwgZGVzdD0weDAwMDAwMDAxMDA5M2RhMDgsCmFsdGRlc3Q9MHgwMDAwMDAw MTAwOTNkYTA4LCBjb21wbGV0aW9uVGFnPSIiKSBhdCBwcXVlcnkuYzo3OTkNCiAgICBmcmFtZSAj MTA6IDB4MDAwMDAwMDEwMDI1YTYzMgpwb3N0Z3Jlc2BFeGVjdXRlUXVlcnkoc3RtdD0weDAwMDAw MDAxMDIwMGFhNDgsCmludG9DbGF1c2U9MHgwMDAwMDAwMDAwMDAwMDAwLCBxdWVyeVN0cmluZz0i ZXhlY3V0ZSB0ZXN0KCQxKSIsCnBhcmFtcz0weDAwMDAwMDAwMDAwMDAwMDAsIGRlc3Q9MHgwMDAw MDAwMTAwOTNkYTA4LCBjb21wbGV0aW9uVGFnPSIiKSBhdApwcmVwYXJlLmM6MzA0Cgo= --===============3160000082019537328==--