Re: Allow to_date() and to_timestamp() to accept localized names

From: Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: James Coleman <jtc331(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Arthur Zakirov <zaartur(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Allow to_date() and to_timestamp() to accept localized names
Date: 2020-03-08 11:16:56
Message-ID: CAC+AXB2VgaC65Y+GoWyjKZttfNJT4i8ums2DFtTcVqoi0wOyag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Mar 8, 2020 at 3:48 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> James Coleman <jtc331(at)gmail(dot)com> writes:
> > On Sat, Mar 7, 2020 at 9:31 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> Looks like you may not have Turkish locale installed? Try
> >> locale -a | grep tr_TR
>
> > Hmm, when I grep the locales I see `tr_TR.utf8` in the output. I assume
> the
> > utf8 version is acceptable? Or is there a non-utf8 variant?
>
> Hmm ... I'm far from an expert on the packaging of locale data, but
> the simplest explanation I can think of is that the tr_TR locale exists
> to some extent on your machine but the LC_TIME component of that is
> missing.
>

AFAICS, the locale 'tr_TR' uses the encoding ISO-8859-9 (LATIN5), is not
the same as 'tr_TR.utf8'.

> BTW, what platform are you using anyway?
>

I have just checked in a Debian Stretch

Regards,

Juan José Santamaría Flecha

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Floris Van Nee 2020-03-08 11:23:08 RE: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare()
Previous Message Alexander Korotkov 2020-03-08 10:47:31 Re: Psql patch to show access methods info