Re: Transactions within Function

On Wed, Apr 4, 2012 at 12:07 PM, Steve Horn <steve@stevehorn.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

--
Andy Chambers
Software Engineer
(e) achambers@mcna.net