From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [SQL] [GENERAL] CURRENT_TIMESTAMP |
Date: | 2002-10-03 23:58:39 |
Message-ID: | 20021003195839.A16643@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
On Thu, Oct 03, 2002 at 07:09:33PM -0400, Tom Lane wrote:
> statement-arrival time. (I like the idea of a parameterized version of
> now() to provide a consistent interface to all three functionalities.)
I like this, too. I think it'd be probably useful. But. . .
> pride of place to statement-arrival time. In the end, I think that
> transaction-start time is the most commonly useful and safest variant,
. . .I also think this is true. If I'm doing a bunch of database
operations in one transaction, there is a remarkably good argument
that they happened "at the same time". After all, the marked passage
of time is probably just an unfortunate side effect of the inability
of my database can't process things instantaneously.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-03 23:59:56 | Re: [GENERAL] Performance while loading data and indexing |
Previous Message | Marc G. Fournier | 2002-10-03 23:50:23 | v7.2.3 Released to fix Potentially Critical Bug |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-03 23:59:56 | Re: [GENERAL] Performance while loading data and indexing |
Previous Message | Tom Lane | 2002-10-03 23:53:39 | Re: [GENERAL] Small patch for PL/Perl Misbehavior with Runtime Error Reporting |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-04 00:41:58 | Re: [SQL] [GENERAL] CURRENT_TIMESTAMP |
Previous Message | Tom Lane | 2002-10-03 23:09:33 | Re: [SQL] [GENERAL] CURRENT_TIMESTAMP |