Re: BUG #9955: The time zone value for South Africa (SAST) is 01:00:00 not 09:30:00 - Mailing list pgsql-bugs

From Vik Fearing
Subject Re: BUG #9955: The time zone value for South Africa (SAST) is 01:00:00 not 09:30:00
Date
Msg-id 53485D6B.8020607@dalibo.com
Whole thread Raw
In response to Re: BUG #9955: The time zone value for South Africa (SAST) is 01:00:00 not 09:30:00  (Vik Fearing <vik.fearing@dalibo.com>)
List pgsql-bugs
On 04/11/2014 11:07 PM, Vik Fearing wrote:
> On 04/11/2014 06:54 PM, Tom Lane wrote:
>> valentin.gora@vitheia.com writes:
>>> Wrong value in pg_timezone_abbrevs ( generated by pg_timezone_abbrevs()
>>> function, implemented internally )
>> This isn't terribly helpful.  What do you think should be changed,
>> exactly, and to what?
> It's in the subject.  The SAST utc_offset is incorrect for South Africa
> and shows instead South Australia because the abbreviation is
> ambiguous.  Not sure if there's anything to do about that.

On the other hand, a Google search for "sast time zone" shows nothing
but South Africa, and "sast time zone australia" still shows South
Africa except for the first result.

And a grep for SAST in the source tree shows:

src/timezone/tznames/Australia.txt:SAST    34200    # South Australian
Standard Time (not in zic)
src/timezone/tznames/Africa.txt:SAST     7200    # South Africa Standard
Time
src/timezone/tznames/Default:SAST    34200    # South Australian
Standard Time (not in zic)

I'm not sure exactly what that means but it would make sense to me that
the default should be the one not marked "not in zic".

--
Vik

pgsql-bugs by date:

Previous
From: Vik Fearing
Date:
Subject: Re: BUG #9955: The time zone value for South Africa (SAST) is 01:00:00 not 09:30:00
Next
From: John R Pierce
Date:
Subject: Re: BUG #9955: The time zone value for South Africa (SAST) is 01:00:00 not 09:30:00