Re: Patch for PKST timezone - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: Patch for PKST timezone
Date
Msg-id 20100511170330.D62D.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Patch for PKST timezone  (Aftab Hussain <aftab.se@gmail.com>)
Responses Re: Patch for PKST timezone
List pgsql-hackers
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?
   ACDT, AEDT, AWDT   BIT   CBT, CDBT, CIST   HMT   PKST, PMT   R*T and R*DT series,   WCDT, WCT, WIB, WITA, WKT

[1] http://www.world-time-zones.org/zones/

> aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$
> aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./psql postgres
> psql (9.0beta1)
> Type "help" for help.
> 
> postgres=# SHOW timezone;
>    TimeZone
> --------------
>  Asia/Karachi
> (1 row)
> 
> postgres=#
> postgres=# CREATE TABLE test_table (c1 INT, c2 TIMESTAMP DEFAULT
> timeofday()::TIMESTAMP);
> CREATE TABLE
> postgres=# INSERT INTO test_table VALUES (1);
> ERROR:  invalid input syntax for type timestamp: "Fri Apr 30 15:36:43.906075
> 2010 PKST"
> postgres=#
> 
> And here is a little bit information about the system I am using.
> 
> aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$  uname -a
> Linux aftab-laptop 2.6.31-20-generic #58-Ubuntu SMP Fri Mar 12 05:23:09 UTC
> 2010 i686 GNU/Linux
> aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$
> aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./pg_config
> --version
> PostgreSQL 9.0beta1
> aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$


Regards,
---
Takahiro Itagaki
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: no universally correct setting for fsync
Next
From: Heikki Linnakangas
Date:
Subject: Re: Patch for PKST timezone