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
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 |