Re: time stops within transaction - Mailing list pgsql-hackers

From Alex Pilosov
Subject Re: time stops within transaction
Date
Msg-id Pine.BSO.4.10.10010182222560.22422-100000@spider.pilosoft.com
Whole thread Raw
In response to Re: time stops within transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: time stops within transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 18 Oct 2000, Tom Lane wrote:

> I think what you are advocating is recomputing now() at each statement
> boundary within a transaction, but that's not as simple as it looks
> either.  Consider statement boundaries in an SQL function --- the
> function is probably being called from some outer statement, so
> advancing now() within the function would violate the spec constraint
> with respect to the outer statement.
Postgres doesn't have an idea of what a 'top-level' statement is? I.E.
statement as submitted by a client (libpq)?

-alex



pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: AW: AW: Backup, restore & pg_dump
Next
From: Tom Lane
Date:
Subject: Re: time stops within transaction