On 2009-05-03, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Sun, May 3, 2009 at 9:38 AM, Wojtek <foo@xxxxxxxx> 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 as type >> from devices_list >> where active = 1 >> LOOP >> (...) >> -- here is CASE statement, checking value of 'type' parameter >> (....) >> END LOOP; --simple enough, right? >> >> This processing is pretty heavy and takes lot of time... so, I'd like to be >> able to monitor as processing progresses and I need to be able to say: >> -which devices've been processed already >> -which ones've not been processed yet > > You could raise notice and then tail the logs as it runs. Or the > other option mentioned of using dblink() works well too. you can retrieve notices through libpq. we're experimenting with using them, and notifies to control the business logic in applications. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
