Colin Mangiagalli ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
