| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Roland Roberts <roland(at)astrofoto(dot)org> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [SQL] CURRENT_TIMESTAMP |
| Date: | 2002-09-24 21:56:51 |
| Message-ID: | 200209242156.g8OLuq815295@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
Roland Roberts wrote:
> >>>>> "Ross" == Ross J Reedstrom <reedstrm(at)rice(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2002-09-24 22:20:10 | Re: problem with maintenance script and missing pg_clog files with pg 7.2.1 |
| Previous Message | Roland Roberts | 2002-09-24 21:48:21 | Re: [SQL] CURRENT_TIMESTAMP |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2002-09-24 22:01:57 | pg_dump and inherited attributes |
| Previous Message | Roland Roberts | 2002-09-24 21:48:21 | Re: [SQL] CURRENT_TIMESTAMP |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Gray | 2002-09-25 01:06:52 | Timestamp Error - 7.2 |
| Previous Message | Roland Roberts | 2002-09-24 21:48:21 | Re: [SQL] CURRENT_TIMESTAMP |