Re: time stops within transaction

Wow, that is strange.


> I just ran into a strangest thing: within transaction, select now() will
> always return time when transaction started. Same happens with select
> 'now'::timestamp.
> 
> This is with 7.0. I have not tested it with CVS.
> 
> I am not sure what causes this. I assume that result of now() is cached by
> fmgr. Is there a way to declare functions 'not-cacheable-ever'? If there
> is, such should be applied to now().
> 
> -alex
> 
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026