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
Curt Sampson [EMAIL PROTECTED] 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';
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.