Ășt 13. 6. 2023 v 15:50 odesĂ­latel Tom Lane <t...@sss.pgh.pa.us> napsal:

> "James Pang (chaolpan)" <chaol...@cisco.com> writes:
> >     Looks like it's the function "regexp_replace" volatile and
> restrict=false make the difference,  we have our application role with
> default search_path=oracle,$user,public,pg_catalog.
> >      =#    select
> oid,proname,pronamespace::regnamespace,prosecdef,proisstrict,provolatile
> from pg_proc where proname='regexp_replace' order by oid;
> >   oid  |    proname     | pronamespace | prosecdef | proisstrict |
> provolatile
> >
> -------+----------------+--------------+-----------+-------------+-------------
> >   2284 | regexp_replace | pg_catalog   | f         | t           | i
> >   2285 | regexp_replace | pg_catalog   | f         | t           | i
> >  17095 | regexp_replace | oracle       | f         | f           | v
> >  17096 | regexp_replace | oracle       | f         | f           | v
> >  17097 | regexp_replace | oracle       | f         | f           | v
> >  17098 | regexp_replace | oracle       | f         | f           | v
>
> Why in the world are the oracle ones marked volatile?  That's what's
> preventing them from being used in index quals.
>

It looks like orafce issue

I'll fix it

Regards

Pavel


>
>                         regards, tom lane
>
>
>

Reply via email to