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

I'll upgrade to 8.2 ASAP. Once in 8.2, which value should I use for timezone
in postgresql.conf?

Thanks and regards,

Jorge

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

> Jorge Campins wrote:
>> How can I find which version I'm using? All I could see in pgAdmin is
>> 8.1.
>
> SELECT version();
>
>
>> 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."
>
> pg_timezone_names was added in 8.2. (which you really should upgrade to
> anyway, since 8.1 isn't supported on Windows anymore)
>
> To find it in 8.1, check the files in share/timezone in your PostgreSQL
> installation.
>
> //Magnus