time stops within transaction - Mailing list pgsql-hackers

From Alex Pilosov
Subject time stops within transaction
Date
Msg-id Pine.BSO.4.10.10010172215430.7579-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: time stops within transaction  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: time stops within transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: time stops within transaction  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Matthew
Date:
Subject: Postgre7.0.2 drop user bug
Next
From: Alex Pilosov
Date:
Subject: time stops/workaround