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
- Re: [HACKERS] time stops within transaction Alex Pilosov
- Re: [HACKERS] time stops within transaction Bruce Momjian
- Re: [HACKERS] time stops within transaction John Huttley
- Re: [HACKERS] time stops within transaction Tom Lane
- Re: [HACKERS] time stops within transaction Peter Eisentraut
- Re: [HACKERS] time stops within transaction Tom Lane
- Re: [HACKERS] time stops within transact... Peter Eisentraut
- Re: [HACKERS] time stops within tra... Tom Lane
- Re: [HACKERS] time stops within... Peter Eisentraut
- Re: [HACKERS] time stops within... Don Baccus