Re: [GENERAL] ERROR: functions in index expression must be markedIMMUTABLE - Mailing list pgsql-general

From Sven R. Kunze
Subject Re: [GENERAL] ERROR: functions in index expression must be markedIMMUTABLE
Date
Msg-id d297e048-ac49-9bed-32e3-9dd4e65d0978@mail.de
Whole thread Raw
In response to Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE
List pgsql-general
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.


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

pgsql-general by date:

Previous
From: Johann Spies
Date:
Subject: Re: [GENERAL] is (not) distinct from
Next
From: Geoff Winkless
Date:
Subject: Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE