Re: Continue transactions after errors in psql

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Continue transactions after errors in psql
Дата
Msg-id 200504251719.j3PHJLu18416@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Continue transactions after errors in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-patches
Greg Sabino Mullane wrote:
> > The current way is ok for me at the moment. I still think there is a better
> > way (parsing statements like it's already done for
> > no-transaction-allowed-statements), but hey, as soon as your patch will be
> > applied, I can myself propose another patch to improve this. ;-)
>
> Parsing the statment will not help: even if the statement is a savepoint, we
> need to wrap it in case we need to roll it back. The only other option I
> can see to my patch is to, upon a successful user savepoint creation,
> roll back their savepoint and immediately reissue it. That seems worse to
> me than having N*2 savepoints though.

Agreed.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Continue transactions after errors in psql
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Continue transactions after errors in psql