Re: keeping track of function execution - Mailing list pgsql-general

From David Rowley
Subject Re: keeping track of function execution
Date
Msg-id CB07FA4D14C54ECFBCF87C0487045FFA@amd64
Whole thread Raw
In response to keeping track of function execution  (Wojtek <foo@twine.pl>)
List pgsql-general
Wojtek wrote:
> But... Postgress treats function as single transaction, of course.
> Hence, I'm not able to see any changes in my progress monitoring table
> until my main function is finished and all the statuses are set to 0.

You could use dblink() to insert into your logging table.

David.


pgsql-general by date:

Previous
From: Wojtek
Date:
Subject: keeping track of function execution
Next
From: Ron Mayer
Date:
Subject: Re: Difference between array column type and separate table