nested transactions
nested transactions
От:
James Gregory <james@anchor.net.au>
Дата:
Hi all, I am writing a stored procedure where it is absolutely necessary that it be executed within a single transaction block. Now, postgres doesn't support nested transactions, and that's ok, it's not really what I want. I want to know how to test whether or not a piece of sql that is executing is doing so inside a transaction. If it is, I'll let it be, otherwise I want to set a flag to start one and commit at the end of the function. Is there a way to do this? Thanks, James.
Re: nested transactions
От:
Martijn van Oosterhout <kleptog@svana.org>
Дата:
Stored procedures are always within a single block. They inherit whatever transaction from the caller. If there is an error, it rollbacks your function (and the callers too IIRC). On Fri, Mar 14, 2003 at 03:11:47PM +0000, James Gregory wrote: > Hi all, > > I am writing a stored procedure where it is absolutely necessary that it > be executed within a single transaction block. Now, postgres doesn't > support nested transactions, and that's ok, it's not really what I want. > I want to know how to test whether or not a piece of sql that is > executing is doing so inside a transaction. If it is, I'll let it be, > otherwise I want to set a flag to start one and commit at the end of the > function. > > Is there a way to do this? > > Thanks, > > James. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Martijn van Oosterhout http://svana.org/kleptog/ > Support bacteria! They're the only culture some people have.
