Time Zone Names Problem

Started by Curt Sampsonalmost 21 years ago3 messages
#1Curt Sampson
cjs@cynic.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Curt Sampson (#1)
Re: Time Zone Names Problem

Curt Sampson <cjs@cynic.net> writes:

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 '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"

Hmm, all of those should work (and do work here). Are the corresponding
files present in the appropriate installation directory? Look under
.../share/postgresql/timezone/

regards, tom lane

#3Curt Sampson
cjs@cynic.net
In reply to: Tom Lane (#2)
Re: Time Zone Names Problem

On Sun, 20 Feb 2005, Tom Lane wrote:

Hmm, all of those should work (and do work here). Are the corresponding
files present in the appropriate installation directory? Look under
.../share/postgresql/timezone/

They are not; it's evidently a problem with the way the NetBSD package
installs things. I'll look into that. Thanks for the tip.

cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.NetBSD.org
Make up enjoying your city life...produced by BIC CAMERA