Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action
Дата
Msg-id 1496997530.2092.53.camel@postgresql.org
обсуждение исходный текст
Ответ на [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action  (vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>)
Ответы Re: [HACKERS] ECPG: WHENEVER statement with DO CONTINUE action  (Vinayak Pokale <vinpokale@gmail.com>)
Список pgsql-hackers
Hi,

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

This did actual escape me. Thanks for bringing it to our attention and
fixing this missing functionality.

> I have tried to implement it. Please check the attached patch.
> Please give me feedback.
> ...

Could you please add a "DO CONTINUE" case to one of the test cases? Or
add a new one? We would need a test case IMO.

Thanks

Michael
-- 
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Meskes at (Debian|Postgresql) dot Org
Jabber: michael at xmpp dot meskes dot org
VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL



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

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: [HACKERS] Surjective functional indexes
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [HACKERS] List of hostaddrs not supported