On 1/2/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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");
>
>                        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

In response to

• Re: TODO: Add a GUC to control whether BEGIN inside at 2007-01-02 17:33:25 from Tom Lane

pgsql-hackers by date

Next:	From: Euler Taveira de Oliveira	Date: 2007-01-04 01:46:57
	Subject: Re: xlog directory at initdb time
Previous:	From: Andrew Dunstan	Date: 2007-01-04 01:05:27
	Subject: Re: [HACKERS] Patch to log usage of temporary files