ecpg did not precompile declare cursor

From: Bernhard Rckerl <bernhard_rueckerl(at)yahoo(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ecpg did not precompile declare cursor
Date: 2002-02-18 21:32:49
Message-ID: 02021822430200.00596@asterix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

I have downloaded postgresql 7.2 on my machine.
Running ecpg on my .ec-file I found that ecpg did not process
the statements "exec sql declare xxx cursor for select.

The part in my .ec-file:
if ( firstcall )
{
calid1 = calid;
EXEC SQL DECLARE CURMFDPOINT CURSOR FOR SELECT STABLE_OR_INSTABLE ,
HIERARCHY , POINT_ID , X1 , P1 , X2 , P2 FROM MANIFOLD_POINTS WHERE
CAL_ID = :calid1;
raiseerror( );
firstcall = false;
}

was transformed into
if ( firstcall )
{
calid1 = calid;
/* declare CURMFDPOINT cursor for select STABLE_OR_INSTABLE , HIERARCHY , POINT_ID , X1 , P1 , X2 , P2 from MANIFOLD_POINTS where CAL_ID = ? */
#line 224 "dbcontrol.ec"

raiseerror( );
firstcall = false;
}
So the declare cursor statement was just commented out. As a consequence the
programm terminated with sqlca.sqlcode=-602 when doing the according
fetch statement.

best regards
Bernhard Rueckerl

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Johnson 2002-02-18 22:09:36 7.2 contrib RPM broken
Previous Message Tom Lane 2002-02-18 17:39:47 Re: Initdb Hangs