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