[BUGS] BUG #2405: how to know if a cursor is open

[RIMBAUD]

The following bug has been logged online:

Bug reference:  2405
Logged by:  RIMBAUD
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system:   Linux RH3
Description:how to know if a cursor is open
Details: 

In pgsql 7.2 , we can close a cursor before creating it even if it doesn't
exist .
In pgsql 8 , this method don't work .
How do i know if a cursor is already open , perhaps in system tables ?? I
don't know .
thanks

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[BUGS] BUG #2206: error on declare cursor after a close cursor

[RIMBAUD Christophe]

The following bug has been logged online:

Bug reference:  2206
Logged by:  RIMBAUD Christophe
Email address:  [EMAIL PROTECTED]
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=#

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match