Re: BUG #3948: date/time functions returning wrong value - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #3948: date/time functions returning wrong value
Date
Msg-id 47AEC5EC.7090202@hagander.net
Whole thread Raw
In response to Re: BUG #3948: date/time functions returning wrong value  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #3948: date/time functions returning wrong value
List pgsql-bugs
Tom Lane wrote:
> Magnus Hagander <magnus@hagander.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

pgsql-bugs by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: BUG #3945: unexpected ON INSERT rule behaviour
Next
From: "Jorge Campins"
Date:
Subject: Re: BUG #3948: date/time functions returning wrong value