Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: gzh <gzhcoder(at)126(dot)com>, Erik Wienhold <ewie(at)ewie(dot)name>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Date: 2023-04-19 17:23:26
Message-ID: 78fb90ea-939d-50d2-0a66-4a760ccbb64e@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

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