On Tue, Aug 16, 2016 at 9:14 AM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Tue, Aug 16, 2016 at 4:19 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> We have certainly not been doing that on a regular basis (as best I can >> tell, no such changes have been made since 2010). Does anybody who uses >> Windows want to deal with it? Or at least do it once so that our Windows >> TZ info is less than 5 years out of date? > > It would be a good idea to refresh that. > >> If we got this done in the next couple weeks, any resulting changes >> could go out in 9.6rc1. Given that we've not done this routinely, >> that seems like a better plan than having them first hit the field >> in minor releases of stable branches. > > Agreed. I'll try to give it a shot in the next couple of days at worst.
I ran the script on my Win10 station, and saw the attached output, which results in the patch attached once changes are applied. Results can be visibly quite different depending on the station used though, Win7 reports other things. Still my guess is that we'd want Win10 as a base. Note as well that the registry has switched to UTC instead of GMT. Thoughts? -- Michael
Timezone Afghanistan Standard Time changed displayname ('(UTC+04:30) Kabul'
from '(GMT+04:30) Kabul')!
Timezone Alaskan Standard Time changed displayname ('(UTC-09:00) Alaska' from
'(GMT-09:00) Alaska')!
Timezone Arab Standard Time changed displayname ('(UTC+03:00) Kuwait, Riyadh'
from '(GMT+03:00) Kuwait, Riyadh')!
Timezone Arabian Standard Time changed displayname ('(UTC+04:00) Abu Dhabi,
Muscat' from '(GMT+04:00) Abu Dhabi, Muscat')!
Timezone Arabic Standard Time changed displayname ('(UTC+03:00) Baghdad' from
'(GMT+03:00) Baghdad')!
Timezone Argentina Standard Time changed displayname ('(UTC-03:00) City of
Buenos Aires' from '(GMT-03:00) Buenos Aires')!
Timezone Atlantic Standard Time changed displayname ('(UTC-04:00) Atlantic Time
(Canada)' from '(GMT-04:00) Atlantic Time (Canada)')!
Timezone AUS Central Standard Time changed displayname ('(UTC+09:30) Darwin'
from '(GMT+09:30) Darwin')!
Timezone AUS Eastern Standard Time changed displayname ('(UTC+10:00) Canberra,
Melbourne, Sydney' from '(GMT+10:00) Canberra, Melbourne, Sydney')!
Timezone Azerbaijan Standard Time changed displayname ('(UTC+04:00) Baku' from
'(GMT+04:00) Baku')!
Timezone Azores Standard Time changed displayname ('(UTC-01:00) Azores' from
'(GMT-01:00) Azores')!
Timezone Bangladesh Standard Time changed displayname ('(UTC+06:00) Dhaka' from
'(GMT+06:00) Dhaka')!
Timezone Canada Central Standard Time changed displayname ('(UTC-06:00)
Saskatchewan' from '(GMT-06:00) Saskatchewan')!
Timezone Caucasus Standard Time changed displayname ('(UTC+04:00) Yerevan' from
'(GMT+04:00) Baku, Tbilisi, Yerevan')!
Timezone Cen. Australia Standard Time changed displayname ('(UTC+09:30)
Adelaide' from '(GMT+09:30) Adelaide')!
Timezone Central America Standard Time changed displayname ('(UTC-06:00)
Central America' from '(GMT-06:00) Central America')!
Timezone Central Asia Standard Time changed displayname ('(UTC+06:00) Astana'
from '(GMT+06:00) Astana, Dhaka')!
Timezone Central Brazilian Standard Time changed displayname ('(UTC-04:00)
Cuiaba' from '(GMT-04:00) Cuiaba')!
Timezone Central Europe Standard Time changed displayname ('(UTC+01:00)
Belgrade, Bratislava, Budapest, Ljubljana, Prague' from '(GMT+01:00) Belgrade,
Bratislava, Budapest, Ljubljana, Prague')!
Timezone Central European Standard Time changed displayname ('(UTC+01:00)
Sarajevo, Skopje, Warsaw, Zagreb' from '(GMT+01:00) Sarajevo, Skopje, Warsaw,
Zagreb')!
Timezone Central Pacific Standard Time changed displayname ('(UTC+11:00)
Solomon Is., New Caledonia' from '(GMT+11:00) Magadan, Solomon Is., New
Caledonia')!
Timezone Central Standard Time changed displayname ('(UTC-06:00) Central Time
(US & Canada)' from '(GMT-06:00) Central Time (US & Canada)')!
Timezone Central Standard Time (Mexico) changed displayname ('(UTC-06:00)
Guadalajara, Mexico City, Monterrey' from '(GMT-06:00) Guadalajara, Mexico
City, Monterrey - New')!
Timezone China Standard Time changed displayname ('(UTC+08:00) Beijing,
Chongqing, Hong Kong, Urumqi' from '(GMT+08:00) Beijing, Chongqing, Hong Kong,
Urumqi')!
Timezone Dateline Standard Time changed displayname ('(UTC-12:00) International
Date Line West' from '(GMT-12:00) International Date Line West')!
Timezone E. Africa Standard Time changed displayname ('(UTC+03:00) Nairobi'
from '(GMT+03:00) Nairobi')!
Timezone E. Australia Standard Time changed displayname ('(UTC+10:00) Brisbane'
from '(GMT+10:00) Brisbane')!
Timezone E. Europe Standard Time changed displayname ('(UTC+02:00) E. Europe'
from '(GMT+02:00) Bucharest')!
Timezone E. South America Standard Time changed displayname ('(UTC-03:00)
Brasilia' from '(GMT-03:00) Brasilia')!
Timezone Eastern Standard Time changed displayname ('(UTC-05:00) Eastern Time
(US & Canada)' from '(GMT-05:00) Eastern Time (US & Canada)')!
Timezone Egypt Standard Time changed displayname ('(UTC+02:00) Cairo' from
'(GMT+02:00) Cairo')!
Timezone Fiji Standard Time changed displayname ('(UTC+12:00) Fiji' from
'(GMT+12:00) Fiji, Kamchatka, Marshall Is.')!
Timezone FLE Standard Time changed displayname ('(UTC+02:00) Helsinki, Kyiv,
Riga, Sofia, Tallinn, Vilnius' from '(GMT+02:00) Helsinki, Kyiv, Riga, Sofia,
Tallinn, Vilnius')!
Timezone Georgian Standard Time changed displayname ('(UTC+04:00) Tbilisi' from
'(GMT+03:00) Tbilisi')!
Timezone GMT Standard Time changed displayname ('(UTC) Dublin, Edinburgh,
Lisbon, London' from '(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon,
London')!
Timezone Greenland Standard Time changed displayname ('(UTC-03:00) Greenland'
from '(GMT-03:00) Greenland')!
Timezone Greenwich Standard Time changed displayname ('(UTC) Monrovia,
Reykjavik' from '(GMT) Casablanca, Monrovia')!
Timezone GTB Standard Time changed displayname ('(UTC+02:00) Athens, Bucharest'
from '(GMT+02:00) Athens, Istanbul, Minsk')!
Timezone Hawaiian Standard Time changed displayname ('(UTC-10:00) Hawaii' from
'(GMT-10:00) Hawaii')!
Timezone India Standard Time changed displayname ('(UTC+05:30) Chennai,
Kolkata, Mumbai, New Delhi' from '(GMT+05:30) Chennai, Kolkata, Mumbai, New
Delhi')!
Timezone Iran Standard Time changed displayname ('(UTC+03:30) Tehran' from
'(GMT+03:30) Tehran')!
Timezone Jerusalem Standard Time changed displayname ('(UTC+02:00) Jerusalem'
from '(GMT+02:00) Jerusalem')!
Timezone Jordan Standard Time changed displayname ('(UTC+02:00) Amman' from
'(GMT+02:00) Amman')!
Timezone Kamchatka Standard Time changed displayname ('(UTC+12:00)
Petropavlovsk-Kamchatsky - Old' from '(GMT+12:00) Petropavlovsk-Kamchatsky')!
Timezone Korea Standard Time changed displayname ('(UTC+09:00) Seoul' from
'(GMT+09:00) Seoul')!
Timezone Mauritius Standard Time changed displayname ('(UTC+04:00) Port Louis'
from '(GMT+04:00) Port Louis')!
Timezone Mid-Atlantic Standard Time changed displayname ('(UTC-02:00)
Mid-Atlantic - Old' from '(GMT-02:00) Mid-Atlantic')!
Timezone Middle East Standard Time changed displayname ('(UTC+02:00) Beirut'
from '(GMT+02:00) Beirut')!
Timezone Montevideo Standard Time changed displayname ('(UTC-03:00) Montevideo'
from '(GMT-03:00) Montevideo')!
Timezone Morocco Standard Time changed displayname ('(UTC) Casablanca' from
'(GMT) Casablanca')!
Timezone Mountain Standard Time changed displayname ('(UTC-07:00) Mountain Time
(US & Canada)' from '(GMT-07:00) Mountain Time (US & Canada)')!
Timezone Mountain Standard Time (Mexico) changed displayname ('(UTC-07:00)
Chihuahua, La Paz, Mazatlan' from '(GMT-07:00) Chihuahua, La Paz, Mazatlan -
New')!
Timezone Myanmar Standard Time changed displayname ('(UTC+06:30) Yangon
(Rangoon)' from '(GMT+06:30) Rangoon')!
Timezone Namibia Standard Time changed displayname ('(UTC+01:00) Windhoek' from
'(GMT+02:00) Windhoek')!
Timezone Nepal Standard Time changed displayname ('(UTC+05:45) Kathmandu' from
'(GMT+05:45) Kathmandu')!
Timezone New Zealand Standard Time changed displayname ('(UTC+12:00) Auckland,
Wellington' from '(GMT+12:00) Auckland, Wellington')!
Timezone Newfoundland Standard Time changed displayname ('(UTC-03:30)
Newfoundland' from '(GMT-03:30) Newfoundland')!
Timezone Pacific SA Standard Time changed displayname ('(UTC-03:00) Santiago'
from '(GMT-04:00) Santiago')!
Timezone Pacific Standard Time changed displayname ('(UTC-08:00) Pacific Time
(US & Canada)' from '(GMT-08:00) Pacific Time (US & Canada); Tijuana')!
Timezone Pacific Standard Time (Mexico) changed displayname ('(UTC-08:00) Baja
California' from '(GMT-08:00) Tijuana, Baja California')!
Timezone Pakistan Standard Time changed displayname ('(UTC+05:00) Islamabad,
Karachi' from '(GMT+05:00) Islamabad, Karachi')!
Timezone Paraguay Standard Time changed displayname ('(UTC-04:00) Asuncion'
from '(GMT-04:00) Asuncion')!
Timezone Romance Standard Time changed displayname ('(UTC+01:00) Brussels,
Copenhagen, Madrid, Paris' from '(GMT+01:00) Brussels, Copenhagen, Madrid,
Paris')!
Timezone SA Eastern Standard Time changed displayname ('(UTC-03:00) Cayenne,
Fortaleza' from '(GMT-03:00) Buenos Aires, Georgetown')!
Timezone SA Pacific Standard Time changed displayname ('(UTC-05:00) Bogota,
Lima, Quito, Rio Branco' from '(GMT-05:00) Bogota, Lima, Quito')!
Timezone SA Western Standard Time changed displayname ('(UTC-04:00) Georgetown,
La Paz, Manaus, San Juan' from '(GMT-04:00) Caracas, La Paz')!
Timezone Samoa Standard Time changed displayname ('(UTC+13:00) Samoa' from
'(GMT-11:00) Midway Island, Samoa')!
Timezone SE Asia Standard Time changed displayname ('(UTC+07:00) Bangkok,
Hanoi, Jakarta' from '(GMT+07:00) Bangkok, Hanoi, Jakarta')!
Timezone Malay Peninsula Standard Time changed displayname ('(UTC+08:00) Kuala
Lumpur, Singapore' from '(GMT+08:00) Kuala Lumpur, Singapore')!
Timezone South Africa Standard Time changed displayname ('(UTC+02:00) Harare,
Pretoria' from '(GMT+02:00) Harare, Pretoria')!
Timezone Sri Lanka Standard Time changed displayname ('(UTC+05:30) Sri
Jayawardenepura' from '(GMT+06:00) Sri Jayawardenepura')!
Timezone Taipei Standard Time changed displayname ('(UTC+08:00) Taipei' from
'(GMT+08:00) Taipei')!
Timezone Tasmania Standard Time changed displayname ('(UTC+10:00) Hobart' from
'(GMT+10:00) Hobart')!
Timezone Tokyo Standard Time changed displayname ('(UTC+09:00) Osaka, Sapporo,
Tokyo' from '(GMT+09:00) Osaka, Sapporo, Tokyo')!
Timezone Tonga Standard Time changed displayname ('(UTC+13:00) Nuku'alofa' from
'(GMT+13:00) Nuku'alofa')!
Timezone Ulaanbaatar Standard Time changed displayname ('(UTC+08:00)
Ulaanbaatar' from '(GMT+08:00) Ulaanbaatar')!
Timezone US Eastern Standard Time changed displayname ('(UTC-05:00) Indiana
(East)' from '(GMT-05:00) Indiana (East)')!
Timezone US Mountain Standard Time changed displayname ('(UTC-07:00) Arizona'
from '(GMT-07:00) Arizona')!
Timezone Coordinated Universal Time changed displayname ('(UTC) Coordinated
Universal Time' from '(GMT) Coordinated Universal Time')!
Timezone UTC+12 changed displayname ('(UTC+12:00) Coordinated Universal
Time+12' from '(GMT+12:00) Coordinated Universal Time+12')!
Timezone UTC-02 changed displayname ('(UTC-02:00) Coordinated Universal
Time-02' from '(GMT-02:00) Coordinated Universal Time-02')!
Timezone UTC-11 changed displayname ('(UTC-11:00) Coordinated Universal
Time-11' from '(GMT-11:00) Coordinated Universal Time-11')!
Timezone Venezuela Standard Time changed displayname ('(UTC-04:30) Caracas'
from '(GMT-04:30) Caracas')!
Timezone W. Australia Standard Time changed displayname ('(UTC+08:00) Perth'
from '(GMT+08:00) Perth')!
Timezone W. Central Africa Standard Time changed displayname ('(UTC+01:00) West
Central Africa' from '(GMT+01:00) West Central Africa')!
Timezone W. Europe Standard Time changed displayname ('(UTC+01:00) Amsterdam,
Berlin, Bern, Rome, Stockholm, Vienna' from '(GMT+01:00) Amsterdam, Berlin,
Bern, Rome, Stockholm, Vienna')!
Timezone West Asia Standard Time changed displayname ('(UTC+05:00) Ashgabat,
Tashkent' from '(GMT+05:00) Islamabad, Karachi, Tashkent')!
Timezone West Pacific Standard Time changed displayname ('(UTC+10:00) Guam,
Port Moresby' from '(GMT+10:00) Guam, Port Moresby')!
Other than that, add the following timezones:
{
"Altai Standard Time", "Altai Daylight Time",
"FIXME"
}, /* (UTC+07:00)
Barnaul, Gorno-Altaysk */
{
"Astrakhan Standard Time", "Astrakhan Daylight Time",
"FIXME"
}, /* (UTC+04:00)
Astrakhan, Ulyanovsk */
{
"Bahia Standard Time", "Bahia Daylight Time",
"FIXME"
}, /* (UTC-03:00)
Salvador */
{
"Belarus Standard Time", "Belarus Daylight Time",
"FIXME"
}, /* (UTC+03:00)
Minsk */
{
"Cabo Verde Standard Time", "Cabo Verde Daylight Time",
"FIXME"
}, /* (UTC-01:00)
Cabo Verde Is. */
{
"Eastern Standard Time (Mexico)", "Eastern Daylight Time
(Mexico)",
"FIXME"
}, /* (UTC-05:00)
Chetumal */
{
"Russia TZ 4 Standard Time", "Russia TZ 4 Daylight Time",
"FIXME"
}, /* (UTC+05:00)
Ekaterinburg */
{
"Russia TZ 1 Standard Time", "Russia TZ 1 Daylight Time",
"FIXME"
}, /* (UTC+02:00)
Kaliningrad */
{
"Libya Standard Time", "Libya Daylight Time",
"FIXME"
}, /* (UTC+02:00)
Tripoli */
{
"Line Islands Standard Time", "Line Islands Daylight Time",
"FIXME"
}, /* (UTC+14:00)
Kiritimati Island */
{
"Magadan Standard Time", "Magadan Daylight Time",
"FIXME"
}, /* (UTC+10:00)
Magadan */
{
"Russia TZ 5 Standard Time", "Russia TZ 5 Daylight Time",
"FIXME"
}, /* (UTC+06:00)
Novosibirsk */
{
"Russia TZ 7 Standard Time", "Russia TZ 7 Daylight Time",
"FIXME"
}, /* (UTC+08:00)
Irkutsk */
{
"Russia TZ 6 Standard Time", "Russia TZ 6 Daylight Time",
"FIXME"
}, /* (UTC+07:00)
Krasnoyarsk */
{
"North Korea Standard Time", "North Korea Daylight Time",
"FIXME"
}, /* (UTC+08:30)
Pyongyang */
{
"Russia TZ 10 Standard Time", "Russia TZ 10 Daylight Time",
"FIXME"
}, /* (UTC+11:00)
Chokurdakh */
{
"Russia TZ 11 Standard Time", "Russia TZ 11 Daylight Time",
"FIXME"
}, /* (UTC+12:00)
Anadyr, Petropavlovsk-Kamchatsky */
{
"Russia TZ 3 Standard Time", "Russia TZ 3 Daylight Time",
"FIXME"
}, /* (UTC+04:00)
Izhevsk, Samara */
{
"Russia TZ 2 Standard Time", "Russia TZ 2 Daylight Time",
"FIXME"
}, /* (UTC+03:00)
Moscow, St. Petersburg, Volgograd */
{
"Sakhalin Standard Time", "Sakhalin Daylight Time",
"FIXME"
}, /* (UTC+11:00)
Sakhalin */
{
"Syria Standard Time", "Syria Daylight Time",
"FIXME"
}, /* (UTC+02:00)
Damascus */
{
"Transbaikal Standard Time", "Transbaikal Daylight Time",
"FIXME"
}, /* (UTC+09:00)
Chita */
{
"Turkey Standard Time", "Turkey Daylight Time",
"FIXME"
}, /* (UTC+02:00)
Istanbul */
{
"Russia TZ 9 Standard Time", "Russia TZ 9 Daylight Time",
"FIXME"
}, /* (UTC+10:00)
Vladivostok */
{
"Russia TZ 8 Standard Time", "Russia TZ 8 Daylight Time",
"FIXME"
}, /* (UTC+09:00)
Yakutsk */
win32-tz-v1.patch
Description: application/download
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
