From: | "RIMBAUD Christophe" <christophe(dot)rimbaud(at)bull(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2206: error on declare cursor after a close cursor |
Date: | 2006-01-24 10:35:22 |
Message-ID: | 20060124103522.9733FF0A2F@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2206
Logged by: RIMBAUD Christophe
Email address: christophe(dot)rimbaud(at)bull(dot)net
PostgreSQL version: 8.1.2
Operating system: Linux Rh3 IA 64
Description: error on declare cursor after a close cursor
Details:
error when i declare a cursor after closing it .
In psql 7.2 it's OK but not in 8.
exemple :
corio=# begin ;
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR,
xid/subid/cid: 50052/1/0, nestlvl: 1, children: <>
DEBUG: ProcessUtility
DEBUG: CommitTransactionCommand
BEGIN
corio=# close PRUTCURSNOLOCK;
DEBUG: StartTransactionCommand
DEBUG: ProcessUtility
ERROR: cursor "prutcursnolock" does not exist
corio=# declare PRUTCURSNOLOCK cursor for select * from PRUT where
UTILCOD >= 'ADMIN ' and PRUTCOLLCOD >= ' ' and SECUMDP >= '
';
DEBUG: StartTransactionCommand
ERROR: current transaction is aborted, commands ignored until end of
transaction block
corio=#
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2006-01-24 11:45:17 | Re: BUG #2182: Internal account lookup failure: |
Previous Message | Reece Hart | 2006-01-24 04:08:38 | Re: BUG #2178: NOT IN command don't work |