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 1tjh9T-00CYmI-9l for pgsql-bugs@arkaria.postgresql.org; Sun, 16 Feb 2025 16:05:51 +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 1tjh9Q-009CEu-CI for pgsql-bugs@arkaria.postgresql.org; Sun, 16 Feb 2025 16:05:48 +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 1tjguF-0099Zx-M6 for pgsql-bugs@lists.postgresql.org; Sun, 16 Feb 2025 15:50:07 +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.96) (envelope-from ) id 1tjguD-00198F-1x for pgsql-bugs@lists.postgresql.org; Sun, 16 Feb 2025 15:50:06 +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=EwqlSexjrl4xf2yEAzFYMsSAH4XncFHlvEvtV4VL14o=; b=VA17MlAD8ZJy0sOR4XFRZDgcc6 MM+kIY2IOlq0GI0uZ5FBry4Ig2xgL/sI5q5b+HcmdKWhzrYH7DhB8j+remQTVPFWnJEiuUObBXlbc 4ZV8H2N1iRS98Zd9Yj78VZYxXdq6grCjEEHmKQXNhJQmT8SutD4i3K9Bnftlov1NuWyXT7FPewihX a8ep28UVwgGaTmoNh/S7Ubj7+/mJmWKDyQruAVxSuRvE4qQwyydzSKBPRJkc47PpHmHuCROVJd2pT L5TAH7o3SWijQnrFHm2bbBs0nhyACi2R8uxnKxI/9Q1QHSkTC0fnUxU5w7lvK8EGM1uhsSieEUPys Y38i78sw==; 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 1tjguC-004hxG-WC for pgsql-bugs@lists.postgresql.org; Sun, 16 Feb 2025 15:50: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 1tjguA-004WXR-QE for pgsql-bugs@lists.postgresql.org; Sun, 16 Feb 2025 15:50:02 +0000 Content-Type: multipart/mixed; boundary="===============8675030843218499933==" MIME-Version: 1.0 Subject: BUG #18813: Materialized view creation regression when inlining recursive SQL function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zeograd@gmail.com Reply-To: zeograd@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 16 Feb 2025 15:49:55 +0000 Message-ID: <18813-d5dadfa976a8ee2e@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 --===============8675030843218499933== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODgxMwpMb2dnZWQgYnk6ICAgICAgICAgIE9saXZpZXIgSm9sbHkKRW1h aWwgYWRkcmVzczogICAgICB6ZW9ncmFkQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE3 LjMKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTIuMiAob2ZmaWNpYWwgZG9ja2VyIGltYWdl cykKRGVzY3JpcHRpb246ICAgICAgICAKCkhpLA0KICBJJ3ZlIGVuY291bnRlcmVkIGFuIGVycm9y IHdoZW4gY3JlYXRpbmcgYSBtYXRlcmlhbGl6ZWQgdmlldyBhcyBJIHVwZGF0ZWQKaXRzIGJvZHkg YnkgaW50cm9kdWNpbmcgYSByZWN1cnNpdmUgZnVuY3Rpb24uDQoNCk9uIHBvc3RncmVTUUwgMTYs IGl0IHdvcmtzIGFzIGV4cGVjdGVkOiB0aGUgbWF0ZXJpYWxpemVkIHZpZXcgaXMgY3JlYXRlZCBh bmQKd29ya3MgYXMgaW50ZW5kZWQuIA0KU3RhcnRpbmcgZnJvbSBwb3NncmVTUUwgMTcuMCwgdGhl IG1hdGVyaWFsaXplZCB2aWV3IGNyZWF0ZWQgZmFpbGVkIHdpdGggdGhlCmVycm9yIG1lc3NhZ2UN Cg0KRVJST1I6ICBmdW5jdGlvbiBqc29uYl9yZWN1cnNpdmVfbWVyZ2UoanNvbmIsIGpzb25iKSBk b2VzIG5vdCBleGlzdA0KTElORSA5OiAgICAgICAgICAgICAgICAgICAgRUxTRSBqc29uYl9yZWN1 cnNpdmVfbWVyZ2UodmE6Ompzb25iLCB2YjouLi4NCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgXg0KSElOVDogIE5vIGZ1bmN0aW9uIG1hdGNoZXMgdGhlIGdpdmVuIG5hbWUgYW5kIGFy Z3VtZW50IHR5cGVzLiBZb3UgbWlnaHQgbmVlZAp0byBhZGQgZXhwbGljaXQgdHlwZSBjYXN0cy4N CkNPTlRFWFQ6ICBTUUwgZnVuY3Rpb24gImpzb25iX3JlY3Vyc2l2ZV9tZXJnZSIgZHVyaW5nIGlu bGluaW5nDQoNCnBvc3RncmVTUUwgMTcuMyBhbHNvIHJldHVybnMgdGhlIHNhbWUgZXJyb3IuDQoN CkEgc29tZXdoYXQgbWluaW1hbCAuc3FsIHNjcmlwdCB0cmlnZ2VyaW5nIHRoZSBlcnJvciAoYXMg d2VsbCBhcyByZXByb2R1Y2libGUKQ0xJIGludm9jYXRpb25zIGFuZCByZXN1bHRzIGZyb20gdGhl IGV4ZWN1dGlvbiBpbiAxNi43LCAxNy4wIGFuZCAxNy4zCm9mZmljaWFsIGRvY2tlciBpbWFnZXMp IGlzIGF2YWlsYWJsZSBvbgpodHRwczovL2dpdGxhYi5jb20vLS9zbmlwcGV0cy80ODA3MzAyDQoN Ckkgd291bGQgZXhwZWN0IHRoYXQgcG9zdGdyZVNRTCAxNy54IGFsbG93cyBjcmVhdGluZyBteSBt YXRlcmlhbGl6ZWQgdmlldwpsaWtlIGl0IGRpZCBpbiBwb3N0Z3JlU1FMIDE2LjcNCg0KVGhhbmtz IGluIGFkdmFuY2UgZm9yIHlvdXIgaGVscCwNCiAgT2xpdmllcgoK --===============8675030843218499933==--