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

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