Re: ERROR: cannot start subtransactions during a parallel operation

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: Mai Peng <maily(dot)peng(at)webedia-group(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: cannot start subtransactions during a parallel operation
Date: 2018-06-29 18:47:41
Message-ID: 20180629184741.wn2pq2ljyde5iolq@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Regina Obe 2018-06-29 18:49:33 RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
Previous Message Tomas Vondra 2018-06-29 18:37:23 Re: ERROR: cannot start subtransactions during a parallel operation