From: | Curt Sampson <cjs(at)cynic(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Time Zone Names Problem |
Date: | 2005-02-21 02:30:41 |
Message-ID: | Pine.NEB.4.61.0502211127380.2795@angelic-vtfw.cvpn.cynic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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: unrecognized time zone name: "Asia/Tokyo"
SET timezone TO 'US/Eastern';
psql:z.sql:4: ERROR: unrecognized time zone name: "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 TIME ZONE '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(at)cynic(dot)net> +81 90 7737 2974 http://www.NetBSD.org
Make up enjoying your city life...produced by BIC CAMERA
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2005-02-21 02:37:58 | Re: postgres crashing on a seemingly good query |
Previous Message | Peter Bierman | 2005-02-21 02:12:25 | Re: Fwd: Apple Darwin disabled fsync? |