transacction problem

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/