ECPG: WHENEVER statement with DO CONTINUE action
vinayak <pokale_vinayak_q3@lab.ntt.co.jp>
From: vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: meskes@postgresql.org
Date: 2017-06-09T08:01:36Z
Lists: pgsql-hackers
Attachments
- whenever-do-continue.patch (binary/octet-stream) patch
Hello, To develop the ECPG application more efficiently and improve portability, I would like to suggest one minor improvement "WHENEVER condition *DO CONTINUE*" support in ECPG. Oracle Pro*C supports WHENEVER statement with DO CONTINUE action.[1] EXEC SQL WHENEVER SQLERROR CONTINUE; is not same as EXEC SQL WHENEVER SQLERROR DO CONTINUE; The CONTINUE action instructs the client application to proceed to the next statement whereas DO CONTINUE action instructs the client application to emit a C continue statement and the flow of control return to the beginning of the enclosing loop. I have tried to implement it. Please check the attached patch. Please give me feedback. [1]https://docs.oracle.com/cd/B28359_01/appdev.111/b28427/pc_09err.htm#i12340 Regards, Vinayak Pokale NTT Open Source Software Center
Commits
-
Fix locale dependency in new ecpg test case.
- aae62278e167 11.0 landed