Time Zone Names Problem

Curt Sampson <cjs@cynic.net>

From: Curt Sampson <cjs@cynic.net>
To: pgsql-hackers@postgresql.org
Date: 2005-02-21T02:30:41Z
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@cynic.net>   +81 90 7737 2974   http://www.NetBSD.org
      Make up enjoying your city life...produced by BIC CAMERA