Re: BUG #2062: Timezone unrecognised

On Mon, Nov 21, 2005 at 03:59:39PM +0000, David Begley wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2062
> Logged by: David Begley
> Email address: d(dot)begley(at)uws(dot)edu(dot)au
> PostgreSQL version: 8.1
> Operating system: Windows
> Description: Timezone unrecognised
> Details:
>
> Sorry this is probably going to be a "PITA" issue.
>
> PostgreSQL documentation (and basic testing with "psql") indicates that for
> the Australian eastern coast, the timezones "AEST" (UTC+10) and "AESST"
> (UTC+11) are recognised; unfortunately the far more popular "AEDT" (UTC+11,
> "Australian Eastern Daylight-Saving Time") is not recognised.
>
> I don't know where the idea that "AESST" is popular in Australia originated
> - a Google for "aesst +site:.au" versus "aedt +site:.au" shows 432 hits for
> "AESST" and over 1.3 million for "AEDT". Even limiting the search to
> ".gov.au" is strongly in favour of "AEDT" (93 versus over 38,000).

The issue is that PostgreSQL gets it's timezone data from somewhere
else; see http://lnk.nu/developer.postgresql.org/69i. Now, why it's
comming from a machine at the National Cancer Institute I don't know...
presumably it's a project for someone who works there. You should take a
look at the comments at the end of
http://lnk.nu/developer.postgresql.org/69j.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461