Re: [PATCHES] Continue transactions after errors in psql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] Continue transactions after errors in psql
Дата
Msg-id 1752.1114525733@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] Continue transactions after errors in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: [PATCHES] Continue transactions after errors in  (Philip Warner <pjw@rhyme.com.au>)
Re: [PATCHES] Continue transactions after errors in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: [PATCHES] Continue transactions after errors in psql  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> To reiterate my opinion, I think the behavior should be the same
> for interactive and non-interactive sessions. Not only will it
> prevent nasty surprises, but unless we make a third 'setting',
> there will be no way to enable this in non-interactive scripts,
> which is something that I would want to be able to do.

I'm finding it hard to visualize a non-interactive script making
any good use of such a setting.  Without a way to test whether
you got an error or not, it would amount to an "ignore errors
within transactions" mode, which seems a pretty bad idea.

Can you show a plausible use-case for such a thing?

            regards, tom lane

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: [PATCHES] Continue transactions after errors in psql
Следующее
От: "Michael Paesold"
Дата:
Сообщение: Re: [PATCHES] Continue transactions after errors in psql