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
> Is there a way I can commit those log inserts in real time?
Use timeofday() rather than current_time.
In response to
pgsql-novice by date
|Next:||From: Merlin Moncure||Date: 2012-04-04 17:21:03|
|Subject: Re: Transactions within Function|
|Previous:||From: Steve Horn||Date: 2012-04-04 16:07:06|
|Subject: Transactions within Function|