how to continue a transaction after an error?

Поиск
Список
Период
Сортировка
От Cristi Petrescu-Prahova
Тема how to continue a transaction after an error?
Дата
Msg-id 002e01c04da9$a8f95c20$25efe6c1@lasting.ro
обсуждение исходный текст
Ответы Re: how to continue a transaction after an error?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: how to continue a transaction after an error?  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
RE: how to continue a transaction after an error?  ("Edmar Wiggers" <edmar@brasmap.com>)
Список pgsql-sql
Hello,

I would like to insert a bunch of rows in a table in a transaction. Some of
the insertions will fail due to constraints violation. When this happens,
Postgres automatically ends the transaction and rolls back all the previous
inserts. I would like to continue the transaction and issue the
commit/rollback command myself.

How to do it?
Is there any setting I am missing?
Is it possible at all?

Thanks,
Cristi



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

Предыдущее
От: Steve Wampler
Дата:
Сообщение: Re: Using a postgres table to maintain unique id?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: how to continue a transaction after an error?