Re: psql metaqueries with \gexec

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Re: psql metaqueries with \gexec
Дата
Msg-id cbf9a1c4-8229-4303-9b17-61a6f3314cbd@mm
обсуждение исходный текст
Ответ на Re: psql metaqueries with \gexec  (Corey Huinker <corey.huinker@gmail.com>)
Ответы Re: psql metaqueries with \gexec  (Corey Huinker <corey.huinker@gmail.com>)
Список pgsql-hackers
    Corey Huinker wrote:

> ...and query text visibility, and result visibility, and error handling,
> etc. In this case, we're leveraging the psql environment we'd already set
> up, and if there's an error, \set ECHO queries shows us the errant SQL as
> if we typed it ourselves..

BTW, about error handling, shouldn't it honor ON_ERROR_STOP ?

With the patch when trying this:

=> set ON_ERROR_STOP on
=> select * from (values ('select 1/0', 'select 1/0')) AS n \gexec

it produces two errors:
ERROR:    division by zero
ERROR:    division by zero

I'd rather have the execution stop immediately after the first error,
like it's the case with successive queries entered normally via the
query buffer:

=> \set ON_ERROR_STOP on
=> select 1/0; select 1/0;
ERROR:    division by zero

as opposed to:

=> \set ON_ERROR_STOP off
=> select 1/0; select 1/0;
ERROR:    division by zero
ERROR:    division by zero


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Add some isolation tests for deadlock detection and resolution.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Writing new unit tests with PostgresNode