On 1/2/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Lukas Kahwe Smith <smith@pooteeweet.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");
>
> regards, tom lane
>
and how the releases and commit will happen? all at once or one by one?
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning." Richard Cook