Colin Mangiagalli (colin@camara.co.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