From: | "Premysl Paska" <premek(dot)paska(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4084: Some DST timezones switche to summer time (one week) later |
Date: | 2008-04-02 11:10:16 |
Message-ID: | 200804021110.m32BAG60053168@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4084
Logged by: Premysl Paska
Email address: premek(dot)paska(at)gmail(dot)com
PostgreSQL version: 8.0.15
Operating system: Linux
Description: Some DST timezones switche to summer time (one week)
later
Details:
We use TIMESTAPM WITH TIMEZONE to insert datetime values into our DB. The
problem is with the CEST timezone (Central European Summer Time; Prague) and
possibly some others.
The summer time started on 2008-03-30 02:00 in the CEST timezone shifting
offset with respect to UTC from +1 to +2. But PostgreSQL kept inserting with
the former +1 offset after this day. We tested it for various other dates
and realized that it switches to the summer time one week later
(2008-04-06).
The same problem was reported with a North American timezone.
(BTW we have another problem with TZ, after we change TZ in the system, we
must restart Postgres to apply it also to the DB.)
From | Date | Subject | |
---|---|---|---|
Next Message | Olivier Bessière | 2008-04-02 12:00:23 | Re: Postgre cant start |
Previous Message | Pedro Gimeno | 2008-04-02 09:14:56 | Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT |