Bug #682: current_timestamp reporting time incorrectly
| От | pgsql-bugs@postgresql.org |
|---|---|
| Тема | Bug #682: current_timestamp reporting time incorrectly |
| Дата | |
| Msg-id | 20020605083817.1D3CA475DE1@postgresql.org обсуждение |
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: