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

[Magnus Hagander <magnus(at)hagander(dot)net>]

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(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