Re: keeping track of function execution

From: "David Rowley" <dgrowley(at)gmail(dot)com>
To: "'Wojtek'" <foo(at)twine(dot)pl>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: keeping track of function execution
Date: 2009-05-03 16:17:16
Message-ID: CB07FA4D14C54ECFBCF87C0487045FFA@amd64
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2009-05-03 16:19:43 Re: Difference between array column type and separate table
Previous Message Wojtek 2009-05-03 15:38:53 keeping track of function execution