Thread

[Keystone Slip # 4] ECPG declare cursor parses, but no data struct in Postgres.

webmaster@postgresql.org — 1999-07-23T16:52:24Z

---------------------------------------------------------------------------
Slip number -----: 4
Problem ---------: ECPG declare cursor parses, but no data struct in Postgres.
Opened by -------: adroffne@advance.net on 07/23/99 11:16
Assigned To -----: momjian
---------------------------------------------------------------------------
Summary:
The embedded SQL statement:
EXEC SQL DECLARE cursor_name CURSOR FOR select_statement;
does form a ECPGdo() call with the preprocessor. Yet, when the code runs, it generates the error:
portal "cursor_name" not defined
Does Postgres (6.5) know how to handle cursor declarations?
---------------------------------------------------------------------------
History:
07/23/99 12:52 by scrappy:
Dependency changed to 0 from 
Current tech changed to momjian from 
Contact changed to  from ANONYMOUS
Scheduled Close Date changed to 0 from 
Scheduled Open Date changed to 0 from 
Public setting changed to 1 from 0
Policy changed to 0

---------------------------------------------------------------------------


          Full information on this slip is available at:
http://www.postgresql.org/bugs/visitor.php3?sid=4&v_func=zoom

---------------------------------------------------------------------------
This message was generated automatically by Keystone at http://www.postgresql.org