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
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 |
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 |