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

Bug #682: current_timestamp reporting time incorrectly

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #682: current_timestamp reporting time incorrectly
Date: 2002-06-05 08:38:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Colin Mangiagalli (colin(at)camara(dot)co(dot)za) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
current_timestamp reporting time incorrectly

Long Description
Postgresql Version: PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC 2.95.3-5
Cygwin dll: 1.3.10
Operating system: Windows 2000 Service Pack 2
Processor: Intel Pentium III 1 Ghz
Bios: Award Moduler Bios v6.00pg

When I start postmaster and run 'select CURRENT_TIMESTAMP;', the date and time are correct. After a hour, I run 'select CURRENT_TIMESTAMP;' and see that the time is not the same as the system clock, in fact it is quite far behind.

Steps to recreate problem:
1. Start postmaster
2. connect to database using psql
3. Issue 'select current_timestamp;' (The time should be synchronized with operating system).
4. Wait 5 minutes (or shorter)
5. Issue 'select current_timestamp;' (The time has lapsed behind)

Sample Code
select current_timestamp;

No file was uploaded with this report

pgsql-bugs by date

Next:From: Sam LiddicottDate: 2002-06-05 09:02:53
Subject: Re: drop tempoary table VERY slow
Previous:From: Tom LaneDate: 2002-06-04 23:21:05
Subject: Re: Transaction isolation with concurrent increments

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