> >The timestamp provided as a result of evaluating 'now' is the time of
> >the start of the transaction, not the instantaneous wall clock time (if
> >you want the latter there is a function to provide it).
> We are now thinking that what is happening is that the first write
> may have a long open transaction.
> What is the function you mention to provide instantaneous time?
lockhart=# select timestamp 'now', cast(timeofday() as timestamp); ?column? | ?column?
------------------------+---------------------------2002-02-01 17:01:19-08 | 2002-02-01 17:01:31.21-08
hth
- Thomas