Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppBZx-0002aI-DW for pgsql-general@arkaria.postgresql.org; Wed, 19 Apr 2023 17:26:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppBZv-0004Xl-AP for pgsql-general@arkaria.postgresql.org; Wed, 19 Apr 2023 17:26:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppBWn-0006QX-Ro for pgsql-general@lists.postgresql.org; Wed, 19 Apr 2023 17:23:33 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ppBWk-003rtj-K2 for pgsql-general@lists.postgresql.org; Wed, 19 Apr 2023 17:23:33 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 8BE415C012B; Wed, 19 Apr 2023 13:23:28 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 19 Apr 2023 13:23:28 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm2; t= 1681925008; x=1682011408; bh=GE9wf9lEBkuMhBEXsC0COKlBAp77s26DWBQ 35nsaBBI=; b=n0y1uav91cdf2847RMqA41hQptbWlja76BQdVYvua+9sctk3OiK Y3VKiAVYDVhxzDcKtaCtrOC/3/uDIX/af28zJYvExVVdKy/nau3iwv0vDuhICRA9 JUAEkyqasSo7xSt2eBZz07zwQSPdaVcUd5l2x7xT1QaR3EZvaQRxwI27Mr/6zONz LJakTZdc6dOlaW7AUhZk+8+QRY6tlGZ6DAaUK1tOIbTXg79IdWSiQ2QDHBU2VMgU wdZeF4Z4aOyX+9igO8W0VUQvVeplvqeIKI3Q3ML6Ggba4n5goeBlNgy3xFXpFFCk XmX0D2KsQUi4rnbnbNhBRhl51WtxbdtvOBg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1681925008; x=1682011408; bh=GE9wf9lEBkuMhBEXsC0COKlBAp77s26DWBQ 35nsaBBI=; b=MGnK0CoWZflnTqhKuyv/R9HQNEzFEcTEMEgYHw9fgtHhqUMEPak MseNNGEAUG6/AjciijsOKWx/n0s7/RlNA9W7D/4OstQAESOjbCQaHA1OZT3L1Ung Dh49ZYpkWgUGUHO9idjq/lrzC9BKRVKnt4rZhC+fStHVyvR6P9Z3ryFDGKq2a5Bz yeflChXuXHT91b8QZfQy60Lli33XXHYqu+EvSMyED/q+DRdKVrBhbSA1WHXyaZHo YUr7LYjppjAmWdTxa0dkhGc7arZjBA4VHWKFcx/6ly8RiycDQ+Whs7rP+MCai8Cw AAT1xr/7CJx3sYDiI5KBuXZ1cgTttg4ce0g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfedttddguddufecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefuvfevfhfhkffffgggjggtgfesthejredttdeftfenucfhrhhomheptegu rhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrd gtohhmqeenucggtffrrghtthgvrhhnpeelveevveduvdfftdektddvuefgvddvfefguedt hefgtdegieevteduheegffffgfenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 19 Apr 2023 13:23:27 -0400 (EDT) Subject: Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist To: gzh , Erik Wienhold Cc: pgsql-general@lists.postgresql.org References: <328d2a0.828a.18799afd0ac.Coremail.gzhcoder@126.com> <1597875806.606392.1681915893771@office.mailbox.org> <70c95d95.7a58.1879a77ed4f.Coremail.gzhcoder@126.com> From: Adrian Klaver Message-ID: <78fb90ea-939d-50d2-0a66-4a760ccbb64e@aklaver.com> Date: Wed, 19 Apr 2023 10:23:26 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.0 MIME-Version: 1.0 In-Reply-To: <70c95d95.7a58.1879a77ed4f.Coremail.gzhcoder@126.com> Content-Type: text/plain; charset=gbk; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/19/23 10:02 AM, gzh wrote: > Thank you for your prompt reply. > Is there another solution if the database is not upgraded to 12.14? > >>Better upgrade to latest release 12.14. > The point being made was that 12.14 is the latest minor release so you might as well upgrade to it. It will not change your situation, as others have pointed out that is a schema/search_path issue. You will still need to resolve that. -- Adrian Klaver adrian.klaver@aklaver.com