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

Bug #780: Timestamp shifted by one minute

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #780: Timestamp shifted by one minute
Date: 2002-09-26 14:43:31
Message-ID: 20020926144331.D4E3A476D8D@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Rob Abbot (rra42(at)yahoo(dot)co(dot)uk) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Timestamp shifted by one minute

Long Description
The output of the code below is:
25/09/02 23:59:00   *NOT*   26/09/02 00:00:00
which is timeshifted backward by 1 minute from the inserted timestamp. In this case the timestamp is shifted backward to the previous day!!!

Details of set-up:
Dell 1650 PowerEdge, 1.13Mhz Pentium III, 512k cache, 512 MB RAM
RedHat Linux 7.1

Result of SELECT version();
"PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96"

Details of build:
(Comments  below from my notes)
Installed postgresql 7.2.1 from source:
the default install is to /usr/local/pgsql/
unpacked in rob, got rob/postgresql-7.2.1 as 'rob'
./configure
gmake (takes forever)
gmake check
su to root and get back to /home/rob/postgresql-7.2.1
gmake install
gmake install-all-headers

This bug appears similar to:
http://archives.postgresql.org/pgsql-bugs/2001-04/msg00072.php

I have another similar setup which works perfectly: the binary was built with the same source tree and options, however the differences between the two setups are:
OS: Suse 7.1
Compiler: GCC 2.95.2
CPU: AMD Athlon 533MHz, 256MB RAM

I am also running PostgreSQL on a Compaq Proliant, RedHat 6.0, PostgreSQL 7.0.3 compiled gcc egcs-2.91.66 again this does not show the timestamp problem.

Best wishes,
Rob


Sample Code
create table timetester (timefield timestamp);
insert into timetester values ('2002-09-26 00:00:00.00');
select * from timetester;

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-09-26 15:01:04
Subject: Re: Bug #780: Timestamp shifted by one minute
Previous:From: fredrik chabotDate: 2002-09-24 19:38:24
Subject: Re: some other backend died abnormally

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