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

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

Thank you for your reply

On Jun 9, 2017 5:39 PM, "Michael Meskes" <meskes@postgresql.org> wrote:
>
> 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.
>
Yes I will add test case and send updated patch.

Regards,
Vinayak Pokale

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: [HACKERS] Notes on testing Postgres 10b1
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] logical replication: \dRp+ and "for all tables"