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?
pgsql-novice by date
|Next:||From: Andy Chambers||Date: 2012-04-04 16:17:53|
|Subject: Re: Transactions within Function|
|Previous:||From: Tom Lane||Date: 2012-04-04 13:53:28|
|Subject: Re: Function returning SETOF returns nothing |