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