Thread

1. Time Zone Names Problem

   Curt Sampson <cjs@cynic.net> — 2005-02-21T02:30:41Z

   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
   
   

2. Re: Time Zone Names Problem

   Tom Lane <tgl@sss.pgh.pa.us> — 2005-02-21T03:29:22Z

   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
   
   

3. Re: Time Zone Names Problem

   Curt Sampson <cjs@cynic.net> — 2005-02-21T04:06:22Z

   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