Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist - Mailing list pgsql-general

From Adrian Klaver
Subject Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Date
Msg-id 78fb90ea-939d-50d2-0a66-4a760ccbb64e@aklaver.com
Whole thread Raw
In response to Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist  (gzh <gzhcoder@126.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Next
From: Bryn Llewellyn
Date:
Subject: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..."