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 1urbae-009HAk-O6 for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Aug 2025 12:18:54 +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 1urbae-002iPR-4M for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Aug 2025 12:18:52 +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 1urbSB-002gWJ-J3 for pgsql-bugs@lists.postgresql.org; Thu, 28 Aug 2025 12:10:08 +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 1urbS9-002Bai-26 for pgsql-bugs@lists.postgresql.org; Thu, 28 Aug 2025 12:10:07 +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=tL0/qSMoPwCR1g7GZLjQkocAEF/ulNXLj/bQexLh6B0=; b=M8zGrC21c7TEJSjEWUHvNMVXjo Zhu/IdXJ3NWQ4BKssHRlpg+JnhMl33cdAnqf8LUzZKSZ7VHsLyoodwpwgCNS1Ux2yN5/4aKBaigEs 8JzJf+QZEuvMhl/g5dfpX1IztEXfzSZMqmPzOKK64DhVPWvtP6YRfAVmIAFfgNi/brFey6Z82jO8x fDRmpyc8mRuBKYijP26CRdrIA6TmWKGvI3e7UxDqyvGqXTHFDSmotiIBNSnR9Vl9Rq8tNzW5DbP6y 3TKshdMr7mZjOjiKzaaSVcBR47ymJU3VPkZIVuuuipay9fsN/Dso2YGwGfQ9bQw4jo3gwQ78nJ0Ui W42rG/yg==; 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 1urbS8-0060Pp-Pp for pgsql-bugs@lists.postgresql.org; Thu, 28 Aug 2025 12:10:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1urbS7-00CXj8-1S for pgsql-bugs@lists.postgresql.org; Thu, 28 Aug 2025 12:10:03 +0000 Content-Type: multipart/mixed; boundary="===============6263871163562886305==" MIME-Version: 1.0 Subject: BUG #19034: Recursive function with sql_body can replace an existing function but can not be created on it's own To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: katja.henke@foo.ag Reply-To: katja.henke@foo.ag, pgsql-bugs@lists.postgresql.org Date: Thu, 28 Aug 2025 12:09:30 +0000 Message-ID: <19034-de0857b4f94ec10c@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 --===============6263871163562886305== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAzNApMb2dnZWQgYnk6ICAgICAgICAgIEthdGphIEhlbmtlCkVtYWls IGFkZHJlc3M6ICAgICAga2F0amEuaGVua2VAZm9vLmFnClBvc3RncmVTUUwgdmVyc2lvbjogMTUu MwpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpBbiBleGlz dGluZyBmdW5jdGlvbiBjYW4gYmUgY29udmVydGVkIGludG8gYSByZWN1cnNpdmUgZnVuY3Rpb24g dGhhdCB1c2VzCnNxbF9ib2R5LiBCdXQgaXQgaXMgbm90IHBvc3NpYmxlIHRvIGNyZWF0ZSB0aGlz IHNhbWUgcmVjdXJzaXZlIGZ1bmN0aW9uCnVzaW5nIENSRUFURSBGVU5DVElPTi4gSW4gb3RoZXIg d29yZHM6IGlmIHlvdSBtYW5hZ2VkIHRvIGhhdmUgYSByZWN1cnNpdmUKZnVuY3Rpb24gd2l0aCBz cWxfYm9keSBpbiB5b3VyIGRhdGFiYXNlLCB5b3UgY2FuJ3Qgc2ltcGx5IHJlc3RvcmUgYSBkdW1w IG9mCnRoaXMgZGF0YWJhc2UuCgpUaGUgZm9sbG93aW5nIHN0YXRlbWVudCByZXN1bHRzIGluCkVS Uk9SOiAgNDI4ODM6IGZ1bmN0aW9uIHBnX3RlbXAuZG9fc29tZXRoaW5nKGludGVnZXIpIGRvZXMg bm90IGV4aXN0CgpDUkVBVEUgRlVOQ1RJT04gcGdfdGVtcC5kb19zb21ldGhpbmcoaW50KSBSRVRV Uk5TIGludApMQU5HVUFHRSBzcWwKUkVUVVJOIENBU0UgV0hFTiAkMSAlIDIgPSAxIFRIRU4gcGdf dGVtcC5kb19zb21ldGhpbmcoJDEgKyAxKSBFTFNFICQxIEVORDsKCkJ1dCB0aGUgY29tYmluYXRp b24gb2YgdGhlIGZvbGxvd2luZyBzdGF0ZW1lbnRzIHdvcmtzLiBJdCBkb2VzIG5vdCBtYXR0ZXIg aWYKdGhlIGZpcnN0IGZ1bmN0aW9uIHVzZXMgc3FsX2JvZHkgb3IgYSBzdHJpbmcgY29uc3RhbnQu CgpDUkVBVEUgRlVOQ1RJT04gcGdfdGVtcC5kb19zb21ldGhpbmcoaW50KSBSRVRVUk5TIGludApM QU5HVUFHRSBzcWwKUkVUVVJOIDQyOwoKQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gcGdfdGVt cC5kb19zb21ldGhpbmcoaW50KSBSRVRVUk5TIGludApMQU5HVUFHRSBzcWwKUkVUVVJOIENBU0Ug V0hFTiAkMSAlIDIgPSAxIFRIRU4gcGdfdGVtcC5kb19zb21ldGhpbmcoJDEgKyAxKSBFTFNFICQx IEVORDsKCg== --===============6263871163562886305==--