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

Re: BUG #3948: date/time functions returning wrong value

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jorge Campins <jrcampins(at)cantv(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3948: date/time functions returning wrong value
Date: 2008-02-10 09:37:48
Message-ID: 47AEC5EC.7090202@hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> Try setting your timezone in postgresql.conf - that should override 
>> whatever Windows has for you.
> 
> Unless his "8.1" is really 8.1.something-pretty-darn-recent, it's
> not going to know about the latest Venezuela DST law change anyway.

Yes, good point.

Or really, since 8.1 is unsupported, to 8.2.most-recent-available if 
possible.


> This does suggest that we'll need to revisit the win32_tzmap[] list
> every so often?

Seems so. It's the first time I've heard of a timezone being *added* and 
not just changed, but obviously it does happen :-(

//Magnus

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2008-02-10 09:39:22
Subject: Re: BUG #3948: date/time functions returning wrong value
Previous:From: Gurjeet SinghDate: 2008-02-10 06:13:47
Subject: Re: BUG #3945: unexpected ON INSERT rule behaviour

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