BUG #1469: ECPG : Can't delete an item pointed by a cursor

From: "Anthony COMMUNIER" <anthony(dot)communier(at)capgemini(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1469: ECPG : Can't delete an item pointed by a cursor
Date: 2005-02-07 23:48:48
Message-ID: 20050207234848.4E3F2F0B02@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1469
Logged by: Anthony COMMUNIER
Email address: anthony(dot)communier(at)capgemini(dot)fr
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lucas Galfaso 2005-02-08 05:23:45 Minor bug in pgAdmin III
Previous Message Michael Guerin 2005-02-07 23:10:13 Re: ERROR: cache lookup failed for relation 17442 (repost)