Curt Sampson <cjs(at)cynic(dot)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