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@sss.pgh.pa.us>
To: "Magnus Hagander" <magnus@hagander.net>
Cc: "Jorge Campins" <jrcampins@cantv.net>; <pgsql-bugs@postgresql.org>
Sent: Saturday, February 09, 2008 8:25 PM
Subject: Re: [BUGS] BUG #3948: date/time functions returning wrong value


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