Обсуждение: postgresql support new time zone TRT

On Tue, Oct 25, 2016 at 7:45 PM, Ziyun Audrey Wang
<ziyun.wang@ericsson.com> wrote:
> Does PostgreSQL support the  new time zone TRT (the new time zone for
> Turkey)?


This would probably have had a better chance of being answered on
pgsql-general than here btw.

As it happens the answer is that the next point release will have the
updated Turkish time zone rules. The change was made on very short
notice and I believe was actually announced and implemented all after
the last point release so there was no chance for it to have been
updated. Politicians it appears have such high regard for computer
programmers that we're expected to see the future.

--
greg

On Tue, Oct 25, 2016 at 7:45 PM, Ziyun Audrey Wang
<ziyun.wang@ericsson.com> wrote:
> Does PostgreSQL support the  new time zone TRT (the new time zone for
> Turkey)?


This would probably have had a better chance of being answered on
pgsql-general than here btw.

As it happens the answer is that the next point release will have the
updated Turkish time zone rules. The change was made on very short
notice and I believe was actually announced and implemented all after
the last point release so there was no chance for it to have been
updated. Politicians it appears have such high regard for computer
programmers that we're expected to see the future.

--
greg

Ziyun Audrey Wang wrote:
> Does PostgreSQL support the  new time zone TRT (the new time zone for Turkey)?

Yes, if you install the latest updates.

https://www.postgresql.org/docs/current/static/release-9-6-1.html says:

> Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey,
> plus historical corrections for Turkey and some regions of Russia. Switch to
> numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.

Yours,
Laurenz Albe

Albe Laurenz <laurenz.albe@wien.gv.at> writes:
> Ziyun Audrey Wang wrote:
>> Does PostgreSQL support the  new time zone TRT (the new time zone for Turkey)?

> Yes, if you install the latest updates.

Note that per
http://mm.icann.org/pipermail/tz-announce/2016-September/000041.html
the IANA TZ folk have not chosen to instantiate "TRT" as a time zone
abbreviation:

     Turkey switched from EET/EEST (+02/+03) to permanent +03,
     effective 2016-09-07.  (Thanks to Burak AYDIN.)  Use "+03" rather
     than an invented abbreviation for the new time.

This is in line with their new policy of not inventing abbreviations
that don't have any real-world currency.  If you have evidence that
"TRT" is actually in use in Turkey, please send it to the TZ list
(not here).

            regards, tom lane

Ziyun Audrey Wang wrote:
> Does PostgreSQL support the  new time zone TRT (the new time zone for Turkey)?

Yes, if you install the latest updates.

https://www.postgresql.org/docs/current/static/release-9-6-1.html says:

> Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey,
> plus historical corrections for Turkey and some regions of Russia. Switch to
> numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.

Yours,
Laurenz Albe

Albe Laurenz <laurenz.albe@wien.gv.at> writes:
> Ziyun Audrey Wang wrote:
>> Does PostgreSQL support the  new time zone TRT (the new time zone for Turkey)?

> Yes, if you install the latest updates.

Note that per
http://mm.icann.org/pipermail/tz-announce/2016-September/000041.html
the IANA TZ folk have not chosen to instantiate "TRT" as a time zone
abbreviation:

     Turkey switched from EET/EEST (+02/+03) to permanent +03,
     effective 2016-09-07.  (Thanks to Burak AYDIN.)  Use "+03" rather
     than an invented abbreviation for the new time.

This is in line with their new policy of not inventing abbreviations
that don't have any real-world currency.  If you have evidence that
"TRT" is actually in use in Turkey, please send it to the TZ list
(not here).

            regards, tom lane