Re: start of transaction (was: Re: [PERFORM] Help with - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: start of transaction (was: Re: [PERFORM] Help with
Date
Msg-id 1069064346.20092.27.camel@fuji.krosing.net
Whole thread Raw
In response to Re: start of transaction (was: Re: [PERFORM] Help with count(*))  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: start of transaction (was: Re: [PERFORM] Help with count(*))
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: start of transaction (was: Re: [PERFORM] Help with
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Background writer process