Re: [GENERAL] CURRENT_TIMESTAMP - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [GENERAL] CURRENT_TIMESTAMP
Date
Msg-id 200209242156.g8OLuq815295@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] CURRENT_TIMESTAMP  (Roland Roberts <roland@astrofoto.org>)
Responses Re: [GENERAL] CURRENT_TIMESTAMP
Re: [GENERAL] CURRENT_TIMESTAMP
List pgsql-sql
Roland Roberts wrote:
> >>>>> "Ross" == Ross J Reedstrom <reedstrm@rice.edu> writes:
>
>     Ross> Oh, interesting datapoint. Let me get this clear - on
>     Ross> oracle, the equivalent of:
>
> Well, I've never gone off to lunch in the middle, but in Oracle 7, I
> had transactions which definitely took as much as a few minutes to
> complete where the timestamp on every row committed was the same.

Can you run a test:

    BEGIN;
    SELECT CURRENT_TIMESTAMP;
    wait 5 seconds
    SELECT CURRENT_TIMESTAMP;

Are the two times the same?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-sql by date:

Previous
From: Roland Roberts
Date:
Subject: Re: [GENERAL] CURRENT_TIMESTAMP
Next
From: Keith Gray
Date:
Subject: Timestamp Error - 7.2