[HACKERS] Time zone database

2011-03-03 Thread Andrew Sullivan
Hackers, Today on the ietf-applications list, I saw this: http://www.ietf.org/mail-archive/web/apps-discuss/current/msg02301.html If there are particular issues with respect to the time zone database stuff that you all have struggled with and want highlighted, feel free to send them to me and

Re: [HACKERS] Time zone database

2011-03-03 Thread Heikki Linnakangas
On 03.03.2011 20:45, Andrew Sullivan wrote: Today on the ietf-applications list, I saw this: http://www.ietf.org/mail-archive/web/apps-discuss/current/msg02301.html If there are particular issues with respect to the time zone database stuff that you all have struggled with and want

Re: [HACKERS] Time zone database

2011-03-03 Thread Andrew Sullivan
On Thu, Mar 03, 2011 at 09:27:58PM +0200, Heikki Linnakangas wrote: Yes, we use David Olson's tz database. According to this proposal, David Olson is retiring, and they propose that IETF takes over maintainership of the tz database. Yeah, I guess I ought to have summarized. That is indeed

[HACKERS] Time zone abbreviations fix

2009-09-06 Thread Joachim Wieland
Hi all, this is a reply to the following post: http://archives.postgresql.org/message-id/7867.1219793...@sss.pgh.pa.us which is also a TODO item: [E] Incomplete itemRevise the src/timezone/tznames abbreviation files: * to add missing abbreviations * to find abbreviations that can be

Re: [HACKERS] Time zone abbreviations fix

2009-09-06 Thread Tom Lane
Joachim Wieland j...@mcknight.de writes: this is a reply to the following post: http://archives.postgresql.org/message-id/7867.1219793...@sss.pgh.pa.us which is also a TODO item: [E] Revise the src/timezone/tznames abbreviation files: * to add missing abbreviations * to find

[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

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';

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.

[HACKERS] time zone?

2003-12-15 Thread Tatsuo Ishii
Hi, it seems there is an inconsistency with time zone handling to me: test=# select version(); version - PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) test=#

Re: [HACKERS] time zone?

2003-12-15 Thread Tom Lane
Tatsuo Ishii [EMAIL PROTECTED] writes: Hi, it seems there is an inconsistency with time zone handling to me: Yeah, the set of time zone names accepted by SET TIME ZONE doesn't have a whole lot to do with the set of time zone names you can specify as part of a timestamptz input string. This is

[HACKERS] Time zone abbreviations and calendars

2003-03-07 Thread Peter Eisentraut
Considering the time zone abbreviations that are accepted on input, I find a couple of bogosities: WDT +09:00 West Australian Daylight Time AWST+08:00 Australia Western Standard Time WADT+08:00 West Australian Daylight Time WST +08:00 West Australian Standard Time WAST

Re: [HACKERS] Time zone abbreviations and calendars

2003-03-07 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Considering the time zone abbreviations that are accepted on input, I find a couple of bogosities: Presumably we can get some local knowledge on those items from list members. I believe that Thomas created the TZ tables on the basis of including

Re: [HACKERS] Time zone questions

2002-03-18 Thread Thomas Lockhart
australia=# select '2002-03-18 00:00:00' at time zone 'Australia/Sydney'; ERROR: Time zone 'australia/sydney' not recognized australia=# set time zone 'Australia/Sydney'; SET VARIABLE australia=# select '2002-03-18 00:00:00'; ?column? - 2002-03-18 00:00:00 Why

[HACKERS] Time zone questions

2002-03-17 Thread Christopher Kings-Lynne
I need to do some timezone manipulation, and I was wondering about this difference: australia=# select version(); version -- PostgreSQL 7.1.3 on i386--freebsd4.4, compiled by GCC 2.95.3 (1 row) australia=#