Re: BUG #3948: date/time functions returning wrong value - Mailing list pgsql-bugs

From Jorge Campins
Subject Re: BUG #3948: date/time functions returning wrong value
Date
Msg-id 000e01c86b8b$70cae370$6401a8c0@EGT1
Whole thread Raw
In response to BUG #3948: date/time functions returning wrong value  ("Jorge Campins" <jrcampins@cantv.net>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #3948: date/time functions returning wrong value
Next
From: Tomas Szepe
Date:
Subject: Re: 8.3.0: vacuum full analyze: "invalid memory alloc request size"