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" <[EMAIL PROTECTED]>
To: "Magnus Hagander" <[EMAIL PROTECTED]>
Cc: "Jorge Campins" <[EMAIL PROTECTED]>; <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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
