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

How can I find which version I'm using? All I could see in pgAdmin is 8.1.

Which value should I use for timezone in postgresql.conf? I tried select *
from pg_timezone_names to get a list of valid time zone names but it failed
with "relation pg_timezone_names does not exist."

Thanks and regards,

Jorge

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <magnus(at)hagander(dot)net>
Cc: "Jorge Campins" <jrcampins(at)cantv(dot)net>; <pgsql-bugs(at)postgresql(dot)org>
Sent: Saturday, February 09, 2008 8:25 PM
Subject: Re: [BUGS] BUG #3948: date/time functions returning wrong value

> 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.
>
> This does suggest that we'll need to revisit the win32_tzmap[] list
> every so often?
>
> regards, tom lane