<div class="WordSection1"><p class="MsoNormal">How does one deal with transactions in PGAgent jobs? I have many
scenarioswhere I will loop through a set of data, run a function on each, and commit whatever succeeds or rollback
whateverfails. In Oracle, I was doing this with pl/sql scripts run via sqlplus and cron. In Postgres, I set them up as
pgAgentjobs but so far it is either committing or rolling back all. Since I cannot do any transactions within the
functionsbeing run by pgAgent, can the pgAgent step SQL contain support for them? <p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal"> </div>
