Transactions in PGAgent Jobs

Поиск
Список
Период
Сортировка
Искать
От
David Greco
Тема
Transactions in PGAgent Jobs
Дата
Msg-id
09e02951e5f042f7aecce3d92d7a86c1@DM2PR08MB302.namprd08.prod.outlook.com
Список

How does one deal with transactions in PGAgent jobs? I have many scenarios where I will loop through a set of data, run a function on each, and commit whatever succeeds or rollback whatever fails. In Oracle, I was doing this with pl/sql scripts run via sqlplus and cron. In Postgres, I set them up as pgAgent jobs but so far it is either committing or rolling back all. Since I cannot do any transactions within the functions being run by pgAgent, can the pgAgent step SQL contain support for them?

 

 

 

 

В списке pgadmin-support по дате отправления
От: Dave Page
Дата:
От: Dave Page
Дата:
FAQ