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

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 > > chos

Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread Tom Lane
Bruce Momjian 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 we're >> t

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 writes: > > 84df54b22e8035addc7108abd9ff6995e8c49264 introduced timestamp > > constructors. In the regression tests, various time zones are tested, > > including America/Metlakatla. Now, if you configure using > > --with-sy

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_

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 p

Re: [HACKERS] New timezones used in regression tests

2014-05-13 Thread Alvaro Herrera
Tom Lane wrote: > Christoph Berg 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 z

Re: [HACKERS] New timezones used in regression tests

2014-05-13 Thread Christoph Berg
Re: Robert Haas 2014-05-13 > On Mon, May 12, 2014 at 7:16 PM, Tom Lane 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 futur

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 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 something like Neh

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 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 th

Re: [HACKERS] New timezones used in regression tests

2014-05-12 Thread Tom Lane
Christoph Berg 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. > Unfortu

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, yo