I'm still mulling the best way to handle this situation.
I have a table that describes work to be processed. This table
includes a description of the work as well as priority and scheduling
information (certain records can only be handled by certain client
processes or at particular times of th
Maybe the best option (specialy if you need users to control the jobs) would be to create a table like this:
CREATE TABLE batchjobs (
id SERIAL,
sql TEXT NOT NULL,
done BOOLEAN NOT NOOL DEFAULT false
);
Then you create a pl/pgsql function that iterates every "undone" record from this
