In 8.2, use pg_timezone_names to find the proper one for you - it'll
exist once you've upgraded :-)
//Magnus
Jorge Campins wrote:
> 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