Transactions within Function

Поиск
Список
Период
Сортировка
От Steve Horn
Тема Transactions within Function
Дата
Msg-id CAFLkBaUh8gTu5d3LxByKasTqjP2C_nt3MwM85gx4XahfpdvaCw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Transactions within Function  (Andy Chambers <achambers@mcna.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Function returning SETOF returns nothing
Следующее
От: Andy Chambers
Дата:
Сообщение: Re: Transactions within Function