ERROR: cannot start subtransactions during a parallel operation

Поиск
Список
Период
Сортировка
От Mai Peng
Тема ERROR: cannot start subtransactions during a parallel operation
Дата
Msg-id 90C7C1DA-36D8-46CC-9D81-80BACA603A40@webedia-group.com
обсуждение исходный текст
Ответы Re: ERROR: cannot start subtransactions during a parallel operation  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения
Hello,

On a pG10.4 instance, my query ( a simple select from a view) throw this error:
ERROR:  cannot start subtransactions during a parallel operation
CONTEXT:  PL/pgSQL function check_validity(ltree[]) line 4 during statement block entry

But prefixing this query by "set max_parallel_workers_gather=0" make it works.

When I take off the column that is checked by a function, no need to add set max_parallel_workers_gather=0 .

How could I continue to use the default max_parallel_workers_gather (2).

Thank you

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: CREATE TABLE .. LIKE .. EXCLUDING documentation
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Fix to not check included columns in ANALYZE on indexes