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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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