ecpg did not precompile declare cursor

Поиск
Список
Период
Сортировка
От Bernhard Rückerl
Тема ecpg did not precompile declare cursor
Дата
Msg-id 02021822430200.00596@asterix
обсуждение исходный текст
Ответы ecpg did not precompile declare cursor  (Lee Kindness <lkindness@csl.co.uk>)
Список 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
fromMANIFOLD_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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Greg Johnson
Дата:
Сообщение: 7.2 contrib RPM broken
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Compiling error