timestamp skew during 7.4 -> 8.2 upgrade

From: Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: timestamp skew during 7.4 -> 8.2 upgrade
Date: 2007-08-09 17:27:55
Message-ID: 20070809172653.GA5235@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 that? Is there a way that would could have avoided
it?

Thanks,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2007-08-09 17:30:07 Re: Interesting abilities of substring
Previous Message Tom Lane 2007-08-09 17:24:57 Re: Interesting abilities of substring