Time Zone Names Problem
От | Curt Sampson |
---|---|
Тема | Time Zone Names Problem |
Дата | |
Msg-id | Pine.NEB.4.61.0502211127380.2795@angelic-vtfw.cvpn.cynic.net обсуждение исходный текст |
Ответы |
Re: Time Zone Names Problem
|
Список | pgsql-hackers |
I'm running PostgreSQL 8.0.1 from the NetBSD pkgsrc package. I'm getting some odd behavior with time zone names: SET timezone TO 'JST'; psql:z.sql:1: ERROR: unrecognized time zone name: "JST" SET timezone TO 'EST'; psql:z.sql:2:ERROR: unrecognized time zone name: "EST" SET timezone TO 'Asia/Tokyo'; psql:z.sql:3: ERROR: unrecognizedtime zone name: "Asia/Tokyo" SET timezone TO 'US/Eastern'; psql:z.sql:4: ERROR: unrecognized time zonename: "US/Eastern" SET timezone TO 'Asia/Tokyo-9'; SET SELECT '2004-08-22 18:42:12' AT TIME ZONE 'Asia/Tokyo'; psql:z.sql:7: ERROR: time zone "asia/tokyo" not recognized SELECT '2004-08-22 18:42:12' AT TIME ZONE'Asia/Tokyo-9'; psql:z.sql:8: ERROR: time zone "asia/tokyo-9" not recognized SELECT '2004-08-22 18:42:12' AT TIMEZONE 'JST'; timezone --------------------- 2004-08-22 18:42:12 (1 row) Anybody have any idea what's going on here? The only patch pkgsrc makes is related to shared library version numbers for a couple of operating systems, so I don't think that this is package-specific. It may be NetBSD-specific, however. cjs -- Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.NetBSD.org Make up enjoying your city life...produced byBIC CAMERA
В списке pgsql-hackers по дате отправления: