Re: [HACKERS] Time Zone Names Problem

2005-02-20 Thread Curt Sampson
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

Re: [HACKERS] Time Zone Names Problem

2005-02-20 Thread Tom Lane
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'; > ps

[HACKERS] Time Zone Names Problem

2005-02-20 Thread Curt Sampson
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 ti