Skip site navigation (1) Skip section navigation (2)

BUG #4528: (rounding?) error with some timezone names

From: "chris wood" <chrisj(dot)wood(at)sympatico(dot)ca>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4528: (rounding?) error with some timezone names
Date: 2008-11-13 14:44:38
Message-ID: 200811131444.mADEic9F008792@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4528
Logged by:          chris wood
Email address:      chrisj(dot)wood(at)sympatico(dot)ca
PostgreSQL version: 8.3.4
Operating system:   Debian
Description:        (rounding?) error with some timezone names
Details: 

again sorry I do not have access to 8.3.5, but it should be a quick check
for anyone who does.

postgresbugs=# select version() ;
                                          version
----------------------------------------------------------------------------
----------------
 PostgreSQL 8.3.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian
4.3.2-1) 4.3.2
(1 row)

postgresbugs=# select * from pg_catalog.pg_timezone_names where name =
'right/Pacific/Wake' ;
        name        | abbrev | utc_offset | is_dst
--------------------+--------+------------+--------
 right/Pacific/Wake | WAKT   | 12:00:00   | f
(1 row)

postgresbugs=# select '2008-01-09 07:00:00-00'::timestamptz at time zone
'right/Pacific/Wake' ;
      timezone
---------------------
 2008-01-09 18:59:37   <<<<<<<<<???????
(1 row)

postgresbugs=# select '2008-01-09 07:00:00-00'::timestamptz at time zone
'WAKT' ;
      timezone
---------------------
 2008-01-09 19:00:00
(1 row)


In version 8.3.1 there were 586 timezone names that manifest a similar
error.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-11-13 14:54:42
Subject: Re: BUG #4528: (rounding?) error with some timezone names
Previous:From: Pavel StehuleDate: 2008-11-13 11:00:58
Subject: Re: BUG #4516: FOUND variable does not work after RETURN QUERY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group