Postgres Pro
Downloads
Home   >   mailing lists

Thread: Time Zone Names Problem

Time Zone Names Problem

From
Curt Sampson
Date:
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

Re: Time Zone Names Problem

From
Tom Lane
Date:
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

Re: Time Zone Names Problem

From
Curt Sampson
Date:
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
byBIC CAMERA