timestamp weirdness

From: Elaine Lindelef <eel(at)cognitivity(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: timestamp weirdness
Date: 2002-02-01 02:20:47
Message-ID: v0421010eb87faa8faae7@[216.244.0.9]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

We are having some strange behavior with PostgreSQL 7.1.3 where rows
are inserted with a timestamp that is out of order... here is the
table description and a few rows:

Table "event_page"
Attribute | Type | Modifier
--------------+--------------------------+----------------------------------
user_id | oid |
session_id | character varying(24) |
course_ident | character varying(128) |
page | character varying(32) |
date | timestamp with time zone | default "timestamp"('now'::text)

69714 | 61381 | yVLsSYYpZIa1G54VnDY7qcz2 | COG_001_ELEARNING |
15.html | 2002-01-31 18:07:21+08
69715 | 61381 | yVLsSYYpZIa1G54VnDY7qcz2 | COG_001_ELEARNING |
16.html | 2002-01-31 18:07:40+08
69717 | 61453 | uZuNbGXsWnXXRECH6PGeFdtf | COG_001_ELEARNING |
1.html | 2002-01-31 18:08:14+08
69718 | 61453 | uZuNbGXsWnXXRECH6PGeFdtf | COG_001_ELEARNING |
15.html | 2002-01-31 18:09:30+08
69719 | 61453 | uZuNbGXsWnXXRECH6PGeFdtf | COG_001_ELEARNING |
16.html | 2002-01-31 18:07:49+08

The oid correctly reflects the order of the insertion of the rows...
but look at the timestamp - the last row has a timestamp _2 minutes
before_ the previous row. How could this be happening? We know row
69719 was inserted _after_ 69718, by probably about 30 seconds.

Thanks much.

Elaine Lindelef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2002-02-01 04:14:02 Re: timestamp weirdness
Previous Message Brett Schwarz 2002-02-01 01:45:12 Re: System commands

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2002-02-01 04:14:02 Re: timestamp weirdness
Previous Message Hiroshi Inoue 2002-02-01 01:08:05 Re: RFD: schemas and different kinds of Postgres objects