BUG #2206: error on declare cursor after a close cursor
От | RIMBAUD Christophe |
---|---|
Тема | BUG #2206: error on declare cursor after a close cursor |
Дата | |
Msg-id | 20060124103522.9733FF0A2F@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2206: error on declare cursor after a close cursor
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2206 Logged by: RIMBAUD Christophe Email address: christophe.rimbaud@bull.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=#
В списке pgsql-bugs по дате отправления: