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

From gzh
Subject Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Date
Msg-id 70c95d95.7a58.1879a77ed4f.Coremail.gzhcoder@126.com
Whole thread Raw
In response to Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist  (Erik Wienhold <ewie@ewie.name>)
Responses Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
List pgsql-general
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.






At 2023-04-19 22:51:33, "Erik Wienhold" <ewie@ewie.name> wrote: >> On 19/04/2023 15:24 CEST gzh <gzhcoder@126.com> wrote: >> >> Hi, >> >> I upgraded the version of PostgreSQL from 12.10 to 12.13, > >Better upgrade to latest release 12.14. > >> when I insert data into the t_mstr table, the to_char function in the t_mstr's >> trigger caused the following error. >> >> psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist >> >> There is no problem before the upgrade and to_char(numeric) function comes >> from the Orafce extension. >> The configuration of the old and new databases is as follows. >> >> Database server (old): PostgreSQL 12.10(orafce3.15) >> Database server (new): PostgreSQL 12.13(orafce3.24) >> >> The new database has successfully installed the orafce 3.24 extension. >> It does not occur in "PostgreSQL 12.10 and orafce 3.15", >> but occurs in "PostgreSQL 12.13 and orafce 3.24", >> so either the difference between 12.10 and 12.13 or the difference between >> orafce 3.15 and 3.24 is suspicious. >> >> What is the reason for the problem? > >orafce 3.22 moved functions to schema oracle: > >https://github.com/orafce/orafce/blob/b492a0f50d5ee866c9870f886401d7c34ad8ccb3/NEWS#L4,L5 >https://github.com/orafce/orafce/commit/86a1b51440ca33a04ef47fc3bb704dee26d16753 > >-- >Erik

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Joins of data-modifying CTE with the target table
Next
From: Tom Lane
Date:
Subject: Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist