Re: Patch for PKST timezone

Takahiro Itagaki wrote:
> Aftab Hussain <aftab.se@gmail.com> wrote:
> 
>> Please accept attached patch for the following problem.
> 
> This patch has not been replied, but I can reproduce the error with:
> =# SET timezone = 'Asia/Karachi';
> =# SELECT timeofday()::timestamptz;
> ERROR:  invalid input syntax for type timestamp with time zone: "Tue May 11 13:26:53.264293 2010 PKST"
> 
> Should we add PKST timezone? Also, I found a list of timezones[1]
> and we don't have 36 tznames in the list. Should we also need them?

I don't think we want to include all timezone names in the default
config, timezone abbreviations aren't always unique for example. But we
should include PKST because we already include PKT; it would be nasty
for an application to work during winter, and stop working when the
daylight saving time begins.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com