Timezones in 8.2.7 - Mailing list pgsql-general

From Joseph S
Subject Timezones in 8.2.7
Date
Msg-id fsboc0$2ct8$1@news.hub.org
Whole thread Raw
Responses Re: Timezones in 8.2.7  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Was there something wrong with the tzdata distributed in 8.2.7?
current_timestamp is still using EST, but the date command run from the
command line is correctly returning EDT


[local]:owl=# select version(), current_timestamp;
                                               version
                             |              now

---------------------------------------------------------------------------------------------------+-------------------------------
  PostgreSQL 8.2.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-3) | 2008-03-25 14:33:11.955247-05
(1 row)

Time: 0.584 ms
[local]:owl=# select now();
               now
-------------------------------
  2008-03-25 14:33:24.291317-05
(1 row)

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL, clusters and load-balance
Next
From: "Malinka Rellikwodahs"
Date:
Subject: Re: select any table