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'; > 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])