Re: We're not lax enough about maximum time zone offset from UTC - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: We're not lax enough about maximum time zone offset from UTC
Date
Msg-id 3243D7B2-982F-4A45-B8CC-6478B839E4B0@justatheory.com
Whole thread Raw
In response to We're not lax enough about maximum time zone offset from UTC  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: We're not lax enough about maximum time zone offset from UTC  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On May 30, 2012, at 3:10 PM, Tom Lane wrote:

> However, as pointed out by Patric, if you dump and restore an old
> timestamptz value in one of these zones, it will fail to restore because
> of the sanity check.  I think therefore that we'd better enlarge the
> allowed range to 15:59:59 either way.

Should you be validating them on a per-time zone basis? Or does it matter?

David



pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: Re: Early hint bit setting
Next
From: Sergey Koposov
Date:
Subject: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile