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" <[EMAIL PROTECTED]>
To: "Jorge Campins" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>; <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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
