From: Hannu Krosing <hannu@tm.ee>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Neil Conway <neilc@samurai.com>
Cc: Will LaShell <will@lashell.net>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: start of transaction (was: Re: [PERFORM] Help with
Date: Mon, 17 Nov 2003 12:19:06 +0200
Message-ID: <1069064346.20092.27.camel@fuji.krosing.net> (raw)
In-Reply-To: <200311170031.hAH0VD328503@candle.pha.pa.us>
References: <200311170031.hAH0VD328503@candle.pha.pa.us>
Bruce Momjian kirjutas E, 17.11.2003 kell 02:31:
> Defining now() as the first call seems pretty arbitrary to me. I can't
> think of any time-based interface that has that API. And what if a
> trigger called now() in an earlier query and you didn't even know about
> it.
That would be OK. The whole point of that previous discussion was to
have now() that returns the same value over the span of the whole
transaction.
It would be even better to have now() that returns the time current
transaction is COMMITted as this is the time other backend become aware
of it ;)
-----------
Hannu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: hannu@tm.ee, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, neilc@samurai.com, will@lashell.net, cbbrowne@acm.org, pgsql-hackers@postgresql.org
Subject: Re: start of transaction (was: Re: [PERFORM] Help with
In-Reply-To: <1069064346.20092.27.camel@fuji.krosing.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox