Обсуждение: transacction problem

Hello.

I have a problem with the transactions.I'm using postgres 7.1.3
Our program connects with he database, then it starts the transaction
with:

EXEC SQL BEGIN;

but in the first SELECT I obtain the next error:

    Error: -603
    Begin: already a transaction in progres;

I have try to put:
EXEC SQL ROLLBACK;
before the BEGIN, but postgres says me that there isn't any transaccion
in progres.

Can you help me?
Thenks

On Wed, Mar 13, 2002 at 09:35:02AM +0100, TPCCUVA wrote:
> Hello.
>
> I have a problem with the transactions.I'm using postgres 7.1.3
> Our program connects with he database, then it starts the transaction
> with:
>
> EXEC SQL BEGIN;
>
> but in the first SELECT I obtain the next error:
>
>     Error: -603
>     Begin: already a transaction in progres;
>
> I have try to put:
> EXEC SQL ROLLBACK;
> before the BEGIN, but postgres says me that there isn't any transaccion
> in progres.

Seems to me you have some kind of auto-transaction mode going on there.
Whatever you are using is add extra begin and end statements for you. The
way to check this is to examine the progresql logfile to determine what
extra stuff is being execute and where from.

HTH,
--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> 11/9/2001 - a new beginning or the beginning of the end?