The following bug has been logged online:
Bug reference: 1469
Logged by: Anthony COMMUNIER
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Aix 5.2,UnixWare 7.1.3,Win32
Description: ECPG : Can't delete an item pointed by a cursor
Details:
The statement : EXEC SQL DELETE FROM <table> WHERE CURRENT OF <cursor name>
(describe in SQL 99) isn't recognize by ecpg
Ecpg returns ERROR: syntax error at or near "CURRENT" for the following
program :
EXEC SQL DECLARE C3_NTF CURSOR FOR
SELECT
NUM_NOTIF,
TYPE_NOTIF,
NOTIFIE,
ACTION,
NB_NVX_MSG
FROM
DISPNTEL
FOR UPDATE;
EXEC OPEN C3_NTF;
...
for(;;)
{
...
EXEC SQL FETCH C3_NTF
INTO :SAPnum_notif,
:SAPtype_notif,
:SAPnotifie:INDnotifie,
:SAPaction:INDaction,
:SAPnb_nvx_msg:INDnb_nvx_msg;
...
EXEC SQL DELETE FROM DISPNTEL WHERE CURRENT OF C3_NTF;
...
}
The yacc grammar do not authorize the keywords CURRENT OF
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
