Re: Transactions within Function

On Wed, Apr 4, 2012 at 11:17 AM, Andy Chambers <achambers(at)mcna(dot)net> wrote:
> On Wed, Apr 4, 2012 at 12:07 PM, Steve Horn <steve(at)stevehorn(dot)cc> wrote:
>> I have a very basic function that performs several steps. Each one of these
>> steps could take a significant amount of time which I would like to track.
>>
>> To do this I am inserting a record to a logging table with a timestamp.
>> After my function runs, all of my log entries have the exact same timestamp.
>> I am assuming this is because they are all being committed in the same
>> transaction.
>>
>> Is there a way I can commit those log inserts in real time?
>
> Use timeofday() rather than current_time.
>
> http://www.postgresql.org/docs/9.1/static/functions-datetime.html

lately, prefer clock_timestamp(), especially if you need to manipulate
the returned time as a timestamp.

merlin