Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread Bruce Momjian
On Mon, May 12, 2014 at 07:16:48PM -0400, Tom Lane wrote: Christoph Berg c...@df7cb.de writes: 84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp constructors. In the regression tests, various time zones are tested, including America/Metlakatla. Now, if you configure using

Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: On Mon, May 12, 2014 at 07:16:48PM -0400, Tom Lane wrote: I agree, that seems an entirely gratuitous choice of zone. It does seem like a good idea to test a zone that has a nonintegral offset from GMT, but we can get that from almost anywhere as long as

Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread David Fetter
On Tue, May 13, 2014 at 09:55:26AM -0400, Alvaro Herrera wrote: Christoph Berg wrote: Of course, Wikipedia has something to say about this: http://en.wikipedia.org/wiki/Timekeeping_on_Mars Nice. I especially like MTC, Mars Time Coordinated. But whatever scheme gets chosen, it won't

Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread Bruce Momjian
On Thu, May 15, 2014 at 02:47:21PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: On Mon, May 12, 2014 at 07:16:48PM -0400, Tom Lane wrote: I agree, that seems an entirely gratuitous choice of zone. It does seem like a good idea to test a zone that has a nonintegral offset

Re: [HACKERS] New timezones used in regression tests

2014-05-13 Thread Christoph Berg
Re: Robert Haas 2014-05-13 ca+tgmobvo--rcsrz-u5fma0mo9xvprptwevsw78odceqjcm...@mail.gmail.com On Mon, May 12, 2014 at 7:16 PM, Tom Lane t...@sss.pgh.pa.us wrote: I'm quite unimpressed by the dependency on Mars/Mons_Olympus, too ... that might not fail *today*, but considering it's a real

Re: [HACKERS] New timezones used in regression tests

2014-05-13 Thread Alvaro Herrera
Tom Lane wrote: Christoph Berg c...@df7cb.de writes: 84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp constructors. In the regression tests, various time zones are tested, including America/Metlakatla. Now, if you configure using --with-system-tzdata, you'll get an error if

Re: [HACKERS] New timezones used in regression tests

2014-05-13 Thread Alvaro Herrera
Christoph Berg wrote: Of course, Wikipedia has something to say about this: http://en.wikipedia.org/wiki/Timekeeping_on_Mars Nice. I especially like MTC, Mars Time Coordinated. But whatever scheme gets chosen, it won't be a standard 24h day, so PostgreSQL has a whole lot of different

Re: [HACKERS] New timezones used in regression tests

2014-05-13 Thread Christoph Berg
Re: Alvaro Herrera 2014-05-13 20140513135526.gr6...@eldon.alvh.no-ip.org I especially like MTC, Mars Time Coordinated. But whatever scheme gets chosen, it won't be a standard 24h day, so PostgreSQL has a whole lot of different problems to solve than to fix that little Mars/Mons_Olympus gem

[HACKERS] New timezones used in regression tests

2014-05-12 Thread Christoph Berg
84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp constructors. In the regression tests, various time zones are tested, including America/Metlakatla. Now, if you configure using --with-system-tzdata, you'll get an error if that zone isn't there. Unfortunately, this is what I'm getting

Re: [HACKERS] New timezones used in regression tests

2014-05-12 Thread Christoph Berg
Re: To PostgreSQL Hackers 2014-05-12 20140512214025.ga31...@msgid.df7cb.de 84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp constructors. In the regression tests, various time zones are tested, including America/Metlakatla. Now, if you configure using --with-system-tzdata, you'll

Re: [HACKERS] New timezones used in regression tests

2014-05-12 Thread Tom Lane
Christoph Berg c...@df7cb.de writes: 84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp constructors. In the regression tests, various time zones are tested, including America/Metlakatla. Now, if you configure using --with-system-tzdata, you'll get an error if that zone isn't there.

Re: [HACKERS] New timezones used in regression tests

2014-05-12 Thread Gavin Flower
On 13/05/14 11:16, Tom Lane wrote: Christoph Berg c...@df7cb.de writes: 84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp constructors. In the regression tests, various time zones are tested, including America/Metlakatla. Now, if you configure using --with-system-tzdata, you'll get

Re: [HACKERS] New timezones used in regression tests

2014-05-12 Thread Robert Haas
On Mon, May 12, 2014 at 7:16 PM, Tom Lane t...@sss.pgh.pa.us wrote: I'm quite unimpressed by the dependency on Mars/Mons_Olympus, too ... that might not fail *today*, but considering it's a real location, assuming it is not in the IANA database seems like a recipe for future failure. Maybe