Hi all, Please accept attached patch for the following problem.
af...@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ af...@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. af...@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 af...@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ af...@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./pg_config --version PostgreSQL 9.0beta1 af...@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ Thanks, -- Aftab Hussain, EntepriseDB http://www.enterprisedb.com
diff --git a/src/timezone/tznames/Asia.txt b/src/timezone/tznames/Asia.txt index 3493e0d..483d314 100644 --- a/src/timezone/tznames/Asia.txt +++ b/src/timezone/tznames/Asia.txt @@ -202,6 +202,7 @@ PETT 43200 # Petropavlovsk-Kamchatski Time # (Asia/Kamchatka) PHT 28800 # Phillipine Time (not in zic) PKT 18000 # Pakistan Time (not in zic) +PKST 21600 D # Pakistan Summer Time (not in zic) QYZT 21600 # Kizilorda Time # (Asia/Qyzylorda) SAKST 39600 D # Sakhalin Summer Time diff --git a/src/timezone/tznames/Default b/src/timezone/tznames/Default index 522eedd..f57673e 100644 --- a/src/timezone/tznames/Default +++ b/src/timezone/tznames/Default @@ -335,6 +335,7 @@ PETT 43200 # Petropavlovsk-Kamchatski Time # (Asia/Kamchatka) PHT 28800 # Phillipine Time (not in zic) PKT 18000 # Pakistan Time (not in zic) +PKST 21600 D # Pakistan Summer Time (not in zic) SGT 28800 # Singapore Time # (Asia/Singapore) TJT 18000 # Tajikistan Time
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers