X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 01C36D1B584 for ; Mon, 17 Nov 2003 10:20:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43067-01 for ; Mon, 17 Nov 2003 06:19:50 -0400 (AST) Received: from fuji.krosing.net (217-159-136-226-dsl.kt.estpak.ee [217.159.136.226]) by svr1.postgresql.org (Postfix) with ESMTP id 41F7CD1B536 for ; Mon, 17 Nov 2003 06:19:47 -0400 (AST) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id hAHAJJJC020269; Mon, 17 Nov 2003 12:19:19 +0200 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id hAHAJ6lF020266; Mon, 17 Nov 2003 12:19:06 +0200 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: start of transaction (was: Re: [PERFORM] Help with From: Hannu Krosing To: Bruce Momjian Cc: Tom Lane , Neil Conway , Will LaShell , Christopher Browne , "pgsql-hackers@postgresql.org" In-Reply-To: <200311170031.hAH0VD328503@candle.pha.pa.us> References: <200311170031.hAH0VD328503@candle.pha.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1069064346.20092.27.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Mon, 17 Nov 2003 12:19:06 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/863 X-Sequence-Number: 47151 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