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.