From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Chip Gobs <chip(dot)gobs(at)noaa(dot)gov> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Implicit Transactions |
Date: | 2004-09-20 12:34:27 |
Message-ID: | 200409201234.i8KCYRK07220@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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, we get an error
> that says we are in a failed transaction. At that point, no statement
> will succeed. The only way we have found to get out of this state is
> to ROLLBACK explicitly.
>
> We are not using explicit transactions. My understanding is that PG
> should be rolling back failed statements when we are not in an
> explicit transaction.
>
> Do we have an incorrect setting, a misunderstanding of how it is
> supposed to work, or a bug? Could anyone enlighten me?
ecpg defaults to open transaction by default. There is a command to
change that in ecpg or during compile I think.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Theodore Petrosky | 2004-09-20 13:46:07 | Re: How to check postgres running or not ? |
Previous Message | Bruce Momjian | 2004-09-20 12:19:27 | Re: How to check postgres running or not ? |