pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (13+ messages)  latest in thread

Message-ID: <1069064346.20092.27.camel@fuji.krosing.net>
Permalink:  ../1069064346.20092.27.camel@fuji.krosing.net/
Also on:    postgresql.org/message-id/1069064346.20092.27.camel@fuji.krosing.net

 · 

reply

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