On Fri, Dec 15, 2006 at 10:17:20AM -0500, Tom Lane wrote:
> >> However, I encounter the problem of timestamp.:-(
> >> Was anyone recognizing this problem?
> > The list of accepted timezones is now configurable, check through the
> > docs how to find the list and set it the way you want.
> Yeah, but why the heck isn't JST in it by default? This seems to have
> slipped through the cracks, because I don't see it anywhere in any of
> the timezonesets/* files. Joachim?
Yes, it got removed, see
http://archives.postgresql.org/pgsql-patches/2006-07/msg00077.php
I checked each of the timezones I removed but I don't have my notes anymore
as to why I thought JST could be removed. Obviously, it shouldn't be
removed...
Appended is a patch that adds JST and JDT into Asia.txt and the Default set.
Joachim
diff -cr cvs/pgsql/src/timezone/tznames/Asia.txt
cvs.build/pgsql/src/timezone/tznames/Asia.txt
*** cvs/pgsql/src/timezone/tznames/Asia.txt 2006-07-25 15:49:21.000000000
+0200
--- cvs.build/pgsql/src/timezone/tznames/Asia.txt 2006-12-15
17:26:10.000000000 +0100
***************
*** 156,161 ****
--- 156,165 ----
IST 7200 # Israel Standard Time
# (this time zone is not contained in the ZIC database)
JAYT 32400 # Jayapura Time (Indonesia) (not in zic)
+ JDT 36000 D # Japan Daylight Time
+ # (Asia/Tokyo)
+ JST 32400 # Japan Standard Time
+ # (Asia/Tokyo)
KDT 36000 D # Korean Daylight Time (not in zic)
KGST 21600 D # Kyrgyzstan Summer Time
# (Asia/Bishkek)
diff -cr cvs/pgsql/src/timezone/tznames/Default
cvs.build/pgsql/src/timezone/tznames/Default
*** cvs/pgsql/src/timezone/tznames/Default 2006-07-25 15:49:21.000000000
+0200
--- cvs.build/pgsql/src/timezone/tznames/Default 2006-12-15
17:26:27.000000000 +0100
***************
*** 283,288 ****
--- 283,292 ----
# - IST: Indian Standard Time (Asia)
IST 7200 # Israel Standard Time (not in zic)
JAYT 32400 # Jayapura Time (Indonesia) (not in zic)
+ JDT 36000 D # Japan Daylight Time
+ # (Asia/Tokyo)
+ JST 32400 # Japan Standard Time
+ # (Asia/Tokyo)
KDT 36000 D # Korean Daylight Time (not in zic)
KGST 21600 D # Kyrgyzstan Summer Time
# (Asia/Bishkek)
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
