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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
