Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint
Дата
Msg-id 26256.1268096127@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> Shouldn't that be back-patched?

> Uh, well, it is going to change the behavior of back branches, and
> because we only got one report of the bug which has existed since 8.2, I
> didn't want to risk it.  Should I?

I would say that the odds of the initial BEGIN failing are negligible
anyway, so what it boils down to is whether a failure on the final
COMMIT needs to be reported.  Seems to me the answer is "yes", and the
only reason we haven't had more complaints is that not too many people
have actually relied on the exit status.  Anyone who *does* look at the
exit status is not going to be happy with the current behavior.

In short: it's a bug, fix it.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint
Следующее
От: Joe Conway
Дата:
Сообщение: Re: machine-readable pg_controldata?