| From: | Matt Miller <mattm(at)epx(dot)com> |
|---|---|
| To: | PostgreSQL - GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Autonomous Transactions |
| Date: | 2005-06-01 15:38:01 |
| Message-ID: | 1117640281.4206.8.camel@dbamm01-linux |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm looking for a way to enable a function to commit a unit of work that
does not affect the caller's transaction. I'm coming from the Oracle
world where I've used the "autonomous_transaction" pragma of PL/SQL to
do this. I'm new to Postgres, but I'm hopeful that I can move our
systems from Oracle.
I realize that a plpgsql function cannot commit, and that a rollback
happens automatically when an exception is raised. Beyond this, I'm not
seeing what transaction management tools I have within a function.
Maybe there is a standard idiom out there that employs nested function
calls or something.
I'm willing to use a different language, or even the libpq API if
necessary.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-06-01 15:38:10 | Re: Can I catch sentences in SQL using triggers? |
| Previous Message | Richard Huxton | 2005-06-01 15:37:01 | Re: Old problem needs solution |