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