Re: ERROR: cannot start subtransactions during a parallel operation

Поиск
Список
Период
Сортировка
От Mai Peng
Тема Re: ERROR: cannot start subtransactions during a parallel operation
Дата
Msg-id CA+-TpmRnkyqDS--2v8f1CbDNumtPyJDtemzj+TzyrJOCn55GtQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: cannot start subtransactions during a parallel operation  (Andres Freund <andres@anarazel.de>)
Ответы Re: ERROR: cannot start subtransactions during a parallel operation  (Robert Haas <robertmhaas@gmail.com>)
Re: ERROR: cannot start subtransactions during a parallel operation  (Andres Freund <andres@anarazel.de>)
Re: ERROR: cannot start subtransactions during a parallel operation  (Mai Peng <maily.peng@webedia-group.com>)
Список pgsql-hackers
Дерево обсуждения
Hello, how could I relax the subtransaction restriction, I used the Parallel Unsafe option, but still have the same issue. 
Rgds.

Le ven. 29 juin 2018 20:47, Andres Freund <andres@anarazel.de> a écrit :
Hi,

On 2018-06-29 20:37:23 +0200, Tomas Vondra wrote:
> My guess is that it's a PL/pgSQL function with an EXCEPTION block, and
> there's no easy way to "fix" that.

Obviously not going to immediately help the OP, but I do think we should
be able to relax the subtransaction restriction around parallelism
without too much work.  Can't allow xids to be assigned, but that's
probably ok for a lot of exception handling cases.

Greetings,

Andres Freund

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Microoptimization of Bitmapset usage in postgres_fdw
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Commitfest 2018-07 is underway