Re: ECPG ERROR FOR "exec sql BEGIN" - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: ECPG ERROR FOR "exec sql BEGIN"
Date
Msg-id 20011204084806.A8782@feivel.credativ.de
Whole thread Raw
In response to ECPG ERROR FOR "exec sql BEGIN"  ("chengong@kobundo.ne.jp" <chengong@kobundo.ne.jp>)
List pgsql-interfaces
On Fri, Nov 30, 2001 at 09:59:28PM +0900, chengong@kobundo.ne.jp wrote:
> I have used ECPG in my program.
> 
> but run "exec sql BEGIN" after connect, have a error message like:
> 
> "sql error BEGIN: already a transaction in progress"

That means you run in auto-transaction mode which is the default. Please use
"ecpg -t" to compile your program if you want to start the transactions
yourself.

The default is that there is always an open transaction.

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!


pgsql-interfaces by date:

Previous
From: "Darko Prenosil"
Date:
Subject: Operator class and index
Next
From: Andreas Kretzer
Date:
Subject: Re: TCL with large objects on Win