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.
Timestamp shifted by one minute
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'
gmake (takes forever)
su to root and get back to /home/rob/postgresql-7.2.1
This bug appears similar to:
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.
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
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-09-26 15:01:04|
|Subject: Re: Bug #780: Timestamp shifted by one minute |
|Previous:||From: fredrik chabot||Date: 2002-09-24 19:38:24|
|Subject: Re: some other backend died abnormally|