On Thu, Aug 09, 2007 at 05:27:55PM +, Louis-David Mitterrand wrote:
Hi,
After our 7.4 to 8.2 upgrade using debian tools, we realized that some
of our timestamps with tz had shifted:
For example '2007-04-01 00:00:00+02' became '2007-03-31 23:00:00+01'
which is on a different month.
On Fri, Aug 10, 2007 at 04:59:52PM -0400, Tom Lane wrote:
Karsten Hilbert [EMAIL PROTECTED] writes:
On Fri, Aug 10, 2007 at 10:11:29AM +0200, Louis-David Mitterrand wrote:
So if I understand correctly, a timestamp_tz is ...
... stored as UTC in the backend
... sent to clients shifted
Louis-David Mitterrand [EMAIL PROTECTED] writes:
But, I found something fishy that particular server:
uruk:~# hwclock
Sat 11 Aug 2007 10:47:36 AM CEST -0.630123 seconds
uruk:~# hwclock --utc
Sat 11 Aug 2007 12:47:39 PM CEST -0.600430 seconds
If this is PC-type
On Fri, Aug 10, 2007 at 10:11:29AM +0200, Louis-David Mitterrand wrote:
So if I understand correctly, a timestamp_tz is ...
... stored as UTC in the backend
... sent to clients shifted by whatever timezone was
requested by the client by one of several mechanisms:
- set timezone to
On Thu, Aug 09, 2007 at 10:49:38AM -0500, Scott Marlowe wrote:
On 8/9/07, Louis-David Mitterrand
[EMAIL PROTECTED] wrote:
Hi,
After our 7.4 to 8.2 upgrade using debian tools, we realized that some
of our timestamps with tz had shifted:
For example '2007-04-01 00:00:00+02' became
Karsten Hilbert [EMAIL PROTECTED] writes:
On Fri, Aug 10, 2007 at 10:11:29AM +0200, Louis-David Mitterrand wrote:
So if I understand correctly, a timestamp_tz is ...
... stored as UTC in the backend
... sent to clients shifted by whatever timezone was
requested by the client by one of
Hi,
After our 7.4 to 8.2 upgrade using debian tools, we realized that some
of our timestamps with tz had shifted:
For example '2007-04-01 00:00:00+02' became '2007-03-31 23:00:00+01'
which is on a different month. Some of our applications were severely
disturbed by that.
Has anyone noticed
On 8/9/07, Louis-David Mitterrand
[EMAIL PROTECTED] wrote:
Hi,
After our 7.4 to 8.2 upgrade using debian tools, we realized that some
of our timestamps with tz had shifted:
For example '2007-04-01 00:00:00+02' became '2007-03-31 23:00:00+01'
which is on a different month. Some of our