pg.ddx.io pgsql-hackers@postgresql.org mailing list archive help / color / mirror / Atom feed From: Tom Lane <tgl@sss.pgh.pa.us>
To: James Coleman <jtc331@gmail.com>
Cc: Juan José SantamarÃa Flecha <juanjo.santamaria@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Mark Dilger <mark.dilger@enterprisedb.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Arthur Zakirov <zaartur@gmail.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Allow to_date() and to_timestamp() to accept localized names
Date: Sat, 07 Mar 2020 21:47:59 -0500
Message-ID: <16894.1583635679@sss.pgh.pa.us> (raw )
In-Reply-To: <CAAaqYe8-PTBympzUioLE8xn_CeK4c16YKDq91CLD43kDDC98GQ@mail.gmail.com >
References: <20200124161814.GA8989@alvherre.pgsql >
<32487.1579882979@sss.pgh.pa.us >
<2f83150e-a2c0-6318-3125-d9b86e421aa2@2ndquadrant.com >
<964.1579884408@sss.pgh.pa.us >
<CAC+AXB1+dHo_DhCTySrqoVaq9WUta9uA+2Ens-bEqDw8X4UbTA@mail.gmail.com >
<ba83b5a7-e63e-5aaf-ac29-745a549f9d7d@2ndquadrant.com >
<aa5d8d96-0eb6-07b9-2caf-0910b313cb56@2ndquadrant.com >
<7212.1580177517@sss.pgh.pa.us >
<2E3D8D71-3B55-4735-A047-1FECE1506CD1@enterprisedb.com >
<d2b20ae0-a377-5edc-504b-80b1792a6bf0@2ndquadrant.com >
<6642.1580223087@sss.pgh.pa.us >
<4144A0A0-4820-458D-A105-D5EC0E0D133B@enterprisedb.com >
<CAC+AXB2uTOaPQ2cxvjgcGF3kRVCucftFwchZdQ5n_F0R+P7KwA@mail.gmail.com >
<dae3654e-aee2-b691-ec82-f8dc43ebfd14@2ndquadrant.com >
<CAC+AXB3ymGCsGaAwYjEZUZG3gK5UO6koSUz=v4Sp_qX6UtOOFQ@mail.gmail.com >
<16875.1583012185@sss.pgh.pa.us >
<6719.1583101530@sss.pgh.pa.us >
<CAC+AXB1oZ7mAavSLHEi0w-WUOAeQbN3hr25gG97253=YCY4aUA@mail.gmail.com >
<29169.1583251740@sss.pgh.pa.us >
<CAAaqYe_rAKoWcGwEWCFYCd1e6MV4KGMUKFt_=GuYy6NA7Ga! 6NQ@mail.gmail.com >
<16113.1583634677@sss.pgh.pa.us >
<CAAaqYe8-PTBympzUioLE8xn_CeK4c16YKDq91CLD43kDDC98GQ@mail.gmail.com >
James Coleman <jtc331@gmail.com> writes:
> On Sat, Mar 7, 2020 at 9:31 PM Tom Lane <tgl@sss.pgh.pa.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.
Do you get different results from "date" depending on the locale?
I get
$ LANG=C date
Sat Mar 7 21:44:24 EST 2020
$ LANG=tr_TR.utf8 date
Cts Mar 7 21:44:26 EST 2020
on my Fedora 30 box.
Another possibility perhaps is that you have partial locale settings
in your environment that are bollixing the test. Try
$ env | grep ^LANG
$ env | grep ^LC_
If there's more than one relevant environment setting, and they
don't all agree, I'm not sure what would happen with our
regression tests.
BTW, what platform are you using anyway?
regards, tom lane
view thread (66+ messages) latest in thread
Message-ID: <16894.1583635679@sss.pgh.pa.us>
Permalink: ../16894.1583635679@sss.pgh.pa.us/
Also on: postgresql.org/message-id/16894.1583635679@sss.pgh.pa.us
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, jtc331@gmail.com, juanjo.santamaria@gmail.com, peter.eisentraut@2ndquadrant.com, mark.dilger@enterprisedb.com, alvherre@2ndquadrant.com, zaartur@gmail.com, tomas.vondra@2ndquadrant.com, pgsql-hackers@lists.postgresql.org
Subject: Re: Allow to_date() and to_timestamp() to accept localized names
In-Reply-To: <16894.1583635679@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox