Thread
-
Bug #307 resolved (concerned timestamp problems)
PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-05-05T15:32:42Z
Bob Soeters (bob@iway.nl) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Bug #307 resolved (concerned timestamp problems) Long Description I was experiencing timestamp problems using versions of PostgreSQL below 7.1 (I've been using 6.5 & 7.0.3). This has been resolved by completing the upgrade to 7.1. It turned out that I had been running psql from version 7.1 but the backend of a version < 7.1 (7.0.3 to be precise). Here's the original reply I posted to Thomas Lockhart: >>> I'm truly sorry about this, shouldn't have posted that bug report, since it was me, after a little research. I run the Mandrake 7.1 distribution, which was equipped with PostgreSQL 6.5, or so I believe. I then upgraded to 7.0.3, through some Mandrake specific RPMs. All was well. I noticed the timestamp error in that version, because I wrote a little Perl DBI exercise and found out that I couldn't insert the timestamp as I had gotten it from the backend, directly. It said "Bad external representation". After overlooking it for a couple of hours (!), I finally saw that the number of seconds were out of range, it was displayed as 2001-04-29 00:00:60.00+02. I then looked in the bugtool database, and saw other users that had the same problem. Also, using functions like date() on the timestamp seemed to make matters worse, adding a day or even a month to the actual inserted timestamp value upon output. I then decided to upgrade to the new PG 7.1 release, from source. So I built it, and thought I had installed it correctly all the way. I found out that the old backend was still running though, so there was now a mix-up of versions. Since I corrected that, I've seen no trouble anymore with the timestamps. Sorry for wasting your valuable time with this faulty bugreport, I should've tested more carefuly. Further, I want to compliment the development team, another great job done with version 7.1, I'm hooked. Keep up the good work. Bob <<< Sample Code No file was uploaded with this report