Transactions within Function - Mailing list pgsql-novice

From Steve Horn
Subject Transactions within Function
Date
Msg-id CAFLkBaUh8gTu5d3LxByKasTqjP2C_nt3MwM85gx4XahfpdvaCw@mail.gmail.com
Whole thread Raw
Responses Re: Transactions within Function  (Andy Chambers <achambers@mcna.net>)
List pgsql-novice
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?

--
Steve Horn

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function returning SETOF returns nothing
Next
From: Andy Chambers
Date:
Subject: Re: Transactions within Function