Re: ODBC Layer and the now() function

Byrne Kevin-kbyrne01 <kbyrne01@motorola.com> writes:
> Moserver receives the event - timestamps it as 't1'
> -- time lapse before moserver computes the transaction and gives it to odbc.
> Txn_begin-  now() gets frozen to 't2'
> Insert - now() should put it as 't2'
> Txn_end()- done.

> So firstly t2 should always be > t1 and the difference could be a few seconds but I found sometimes t2 < t1!..

I'd wonder about clock skew between the machine that's running
"moserver" and the machine running Postgres.

Another possibility is that the "transaction begin" doesn't happen when
you think it does.  Sometimes driver-level code like ODBC will issue
BEGIN behind your back ...

            regards, tom lane