Re: [SQL] Implicit Transactions

2004-09-20 Thread Bruce Momjian
Chip Gobs wrote: > > We are porting from Informix to PostgreSQL 7.4.5 and have noticed the > following behavior. > > If we try to OPEN a CURSOR for an invalid SELECT statement in ECPG, we > get an error, as expected. However, if we then > attempt to OPEN another CURSOR for a valid statement,

[SQL] Implicit Transactions

2004-09-18 Thread Chip Gobs
We are porting from Informix to PostgreSQL 7.4.5 and have noticed the following behavior. If we try to OPEN a CURSOR for an invalid SELECT statement in ECPG, we get an error, as expected. However, if we then attempt to OPEN another CURSOR for a valid statement, we get an error that says we ar