út 13. 6. 2023 v 16:17 odesílatel Pavel Stehule <pavel.steh...@gmail.com>
napsal:

>
>
> ú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
>

should be fixed in orafce 4.4.

Regards

Pavel


>
> Regards
>
> Pavel
>
>
>>
>>                         regards, tom lane
>>
>>
>>

Reply via email to