Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Date
Msg-id 2993958.1681924695@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist  (gzh <gzhcoder@126.com>)
Responses Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
List pgsql-general
Tree view 
gzh  <gzhcoder@126.com> writes:
> Thank you for your prompt reply. 
> Is there another solution if the database is not upgraded to 12.14?

The solution is the same whether you upgrade or not: you need
to adjust your search_path to include the "oracle" schema,
or else explicitly qualify references to orafce functions.

            regards, tom lane

pgsql-general by date:

Previous
From: gzh
Date:
Subject: Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist
Next
From: Adrian Klaver
Date:
Subject: Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist