Re: Changing behavior of BEGIN...sleep...do something...COMMIT - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Date
Msg-id 200305261835.h4QIZsO10723@candle.pha.pa.us
Whole thread Raw
In response to Re: Changing behavior of BEGIN...sleep...do something...COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Doug McNaught wrote:
> >> Maybe clock_time() and statement_time(), with transaction_time() an
> >> alias for now() (if that's seemed necessary)?
> 
> I could go with that ...
> 
> > We already have CURRENT_TIMESTAMP.  Would CLOCK_TIMESTAMP,
> > TRANSACTION_TIMESTAMP, and STATEMENT_TIMESTAMP make sense, with
> > CURRENT_TIMESTAMP being the same as TRANSACTION_TIMESTAMP?
> 
> ... or that.  But, please, *not* the weird no-parentheses syntax that
> CURRENT_TIMESTAMP has.  Make it clock_timestamp() and so on.

TODO updated:
* Add transaction_timestamp(), statement_timestamp(), clock_timestamp()  functionality

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Removing a user's password
Next
From: Bruce Momjian
Date:
Subject: Re: Changing behavior of BEGIN...sleep...do something...COMMIT