Tom Lane wrote:
> Lukas Kahwe Smith <smith(at)pooteeweet(dot)org> writes:
>> Err, I think you misunderstood what I said. My implementation uses
>> SAVEPOINTs already. The point is having some API where you do not have
>> to care of you are already in a transaction or not.
>
> It's not that hard, is it?
>
> if (PQtransactionStatus(conn) == PQTRANS_IDLE)
> PQexec(conn, "BEGIN");
> else
> PQexec(conn, "SAVEPOINT foo");
Its not exactly convenient either, especially in the case of modular
code that may be developed by different people. Anyways, like I said I
have a solution in my framework to make life of module developers
easier. Obviously proper nested transactions would be the ideal, but so
it goes. I was just throwing this out here when I saw Peter's comment.
regards,
Lukas