Skip site navigation (1) Skip section navigation (2)

Re: We're not lax enough about maximum time zone offset from UTC

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com>
Subject: Re: We're not lax enough about maximum time zone offset from UTC
Date: 2012-05-30 23:07:23
Message-ID: 3243D7B2-982F-4A45-B8CC-6478B839E4B0@justatheory.com (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-hackers by date

Next:From: Sergey KoposovDate: 2012-05-30 23:16:27
Subject: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile
Previous:From: Ants AasmaDate: 2012-05-30 22:40:13
Subject: Re: Early hint bit setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group