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

From Tom Lane
Subject Re: We're not lax enough about maximum time zone offset from UTC
Date
Msg-id 13846.1338420820@sss.pgh.pa.us
Whole thread Raw
In response to Re: We're not lax enough about maximum time zone offset from UTC  ("David E. Wheeler" <david@justatheory.com>)
List pgsql-hackers
"David E. Wheeler" <david@justatheory.com> writes:
> 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?

We can't really --- a given input string should be valid, or not,
independently of what TimeZone is set to.  If we change that we're far
too likely to break scenarios that work now.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: WalSndWakeup() and synchronous_commit=off
Next
From: Noah Misch
Date:
Subject: Re: Not quite a security hole: CREATE LANGUAGE for non-superusers