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

["Jorge Campins" <jrcampins(at)cantv(dot)net>]

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