| From: | David Greco <David_Greco(at)harte-hanks(dot)com> |
|---|---|
| To: | "PgAdmin Support (pgadmin-support(at)postgresql(dot)org)" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Transactions in PGAgent Jobs |
| Date: | 2013-09-04 16:16:12 |
| Message-ID: | 09e02951e5f042f7aecce3d92d7a86c1@DM2PR08MB302.namprd08.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2013-09-04 16:41:14 | Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1" |
| Previous Message | Dave Page | 2013-09-04 07:26:34 | Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1" |