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@hagander.net>
To: "Jorge Campins" <jrcampins@cantv.net>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; <pgsql-bugs@postgresql.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