time stops within transaction

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: time stops within transaction
Date: 2000-10-18 02:20:10
Message-ID: Pine.BSO.4.10.10010172215430.7579-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Pilosov 2000-10-18 02:40:33 time stops/workaround
Previous Message Matthew 2000-10-18 01:32:43 Postgre7.0.2 drop user bug