From: | "Ross Williams" <ross(dot)williams(at)watchguard(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5912: Etc/GMT time utc offset error |
Date: | 2011-03-03 16:13:34 |
Message-ID: | 201103031613.p23GDYfj080559@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: 5912
Logged by: Ross Williams
Email address: ross(dot)williams(at)watchguard(dot)com
PostgreSQL version: 8.3.1 and 8.4.7
Operating system: FreeBSD 7.3 and Ubuntu 10
Description: Etc/GMT time utc offset error
Details:
On the target OS the offsets are correct GMT+ gives a increased utc_offset.
When I attempt to set via postgres, the timezone are flipped + for - and
vice versa.
http://wwp.greenwichmeantime.com/info/timezone.htm
Gives a clear indication that there is an error in the utc_offset below.
name | abbrev | utc_offset | is_dst
Etc/GMT-14 | GMT-14 | 14:00:00 | f
Etc/GMT-13 | GMT-13 | 13:00:00 | f
Etc/GMT-12 | GMT-12 | 12:00:00 | f
Etc/GMT-11 | GMT-11 | 11:00:00 | f
Etc/GMT-10 | GMT-10 | 10:00:00 | f
Etc/GMT-9 | GMT-9 | 09:00:00 | f
Etc/GMT-8 | GMT-8 | 08:00:00 | f
Etc/GMT-7 | GMT-7 | 07:00:00 | f
Etc/GMT-6 | GMT-6 | 06:00:00 | f
Etc/GMT-5 | GMT-5 | 05:00:00 | f
Etc/GMT-4 | GMT-4 | 04:00:00 | f
Etc/GMT-3 | GMT-3 | 03:00:00 | f
Etc/GMT-2 | GMT-2 | 02:00:00 | f
Etc/GMT-1 | GMT-1 | 01:00:00 | f
Etc/GMT+1 | GMT+1 | -01:00:00 | f
Etc/GMT+2 | GMT+2 | -02:00:00 | f
Etc/GMT+3 | GMT+3 | -03:00:00 | f
Etc/GMT+4 | GMT+4 | -04:00:00 | f
Etc/GMT+5 | GMT+5 | -05:00:00 | f
Etc/GMT+6 | GMT+6 | -06:00:00 | f
Etc/GMT+7 | GMT+7 | -07:00:00 | f
Etc/GMT+8 | GMT+8 | -08:00:00 | f
Etc/GMT+9 | GMT+9 | -09:00:00 | f
Etc/GMT+10 | GMT+10 | -10:00:00 | f
Etc/GMT+11 | GMT+11 | -11:00:00 | f
Etc/GMT+12 | GMT+12 | -12:00:00 | f
From | Date | Subject | |
---|---|---|---|
Next Message | Ross Barrett | 2011-03-03 16:14:22 | Re: BUG #5899: Memory corruption when running psql |
Previous Message | Robert Haas | 2011-03-03 16:12:14 | Re: BUG #5818: initdb lose the single quote of locale |