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
