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