Re: ERROR: functions in index expression must be marked IMMUTABLE

"Sven R. Kunze" <srkunze@xxxxxxx> · Wed, 1 Mar 2017 14:36:15 +0100



    On 28.02.2017 17:50, David G. Johnston
      wrote:

    
          That would
            seem to be it.
          

          cache_locale_time()
            at the top of DCH_to_char which is in the call stack of the
            shared parsing code for both to_date and to_timestamp.
          

          https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/utils/adt/formatting.c;h=e552c8d20b61a082049068d2f8d776e35fef1179;hb=HEAD#l2363
          

          Supposedly
            one could provide a version of to_date that accepts a locale
            in which to interpret names in the input data - or extend
            the format string with some kind of "{locale=en_US}" syntax
            to avoid changing the function signature.
          

          David J.
        
      
    I don't know if this is the right way and list to ask for this:

    
    But if this is acceptable, I would be willing to contribute a patch
    to enable exactly this.

    
    Regards,

    Sven