Scott Marlowe wrote:
On Sun, May 3, 2009 at 9:38 AM, Wojtek f...@twine.pl wrote:
(...)
You could raise notice and then tail the logs as it runs. Or the
other option mentioned of using dblink() works well too.
dblink did the trick, thanks guys!
foo
--
Sent via pgsql-general
On 2009-05-03, Scott Marlowe scott.marl...@gmail.com wrote:
On Sun, May 3, 2009 at 9:38 AM, Wojtek f...@twine.pl wrote:
Hi,
I have a question on transactions/isolation levels/etc...
In my PL/pgSQL function main loop goes through inventory list of active
devices, for each one executing
Hi,
I have a question on transactions/isolation levels/etc...
In my PL/pgSQL function main loop goes through inventory list of active
devices, for each one executing processing applicable for given device,
like:
FOR i in --i is %rowtype
select device_id as device_id,
type as type
from
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.
--
Wojtek wrote:
Hi,
I have a question on transactions/isolation levels/etc...
In my PL/pgSQL function main loop goes through inventory list of active
devices, for each one executing processing applicable for given device,
like:
FOR i in --i is %rowtype
select device_id as device_id,
type
On Sun, May 3, 2009 at 9:38 AM, Wojtek f...@twine.pl wrote:
Hi,
I have a question on transactions/isolation levels/etc...
In my PL/pgSQL function main loop goes through inventory list of active
devices, for each one executing processing applicable for given device,
like:
FOR i in --i is