From: | jlsanz1983(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11822: ECPG Commit or Rollback error |
Date: | 2014-10-29 10:13:20 |
Message-ID: | 20141029101320.2596.63082@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11822
Logged by: jls1983
Email address: jlsanz1983(at)gmail(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOs 6.2
Description:
I use a 8.2 version of postgres, and get and solve the following mistake in
a pgc program:
Hi when a cursor is open and a fetch is in progres if then uses a commit or
rollback instruction before close the cursor.
The cursor get this error:
==== sqlca ====
sqlcode: -400
sqlerrm.sqlerrml: 44
sqlerrm.sqlerrmc: cursor "bolas" does not exist on line 141
sqlerrd: 0 0 0 0 0 0
sqlwarn: 0 0 0 0 0 0 0 0
sqlstate: 34000
===============
If the commit goes after close the cursor then the execution doesn't return
any error.
Sorry about my english.
Best regards.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-10-29 12:45:25 | Re: BUG #11455: PQerrorMessage not reset after PQreset |
Previous Message | chenhj | 2014-10-29 09:38:33 | Re: psql treat backslash which is not the first character in the input line as meta-command |