Re: Execute INSERT during a parallel operation

From: Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>
To: Donald Dong <xdong(at)csumb(dot)edu>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Execute INSERT during a parallel operation
Date: 2019-04-26 14:51:26
Message-ID: CA+FpmFfgGsYTdva=jXoDi-FV34W0REZk2eV_YD00nSAMosd+aQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 14 Apr 2019 at 04:11, Donald Dong <xdong(at)csumb(dot)edu> wrote:
>
> Hi,
>
> I'm trying to use the SPI to save the executed plans in the ExecutorEnd. When the plan involves multiple workers, the insert operations would trigger an error: cannot execute INSERT during a parallel operation.
>
> I wonder if there's a different hook I can use when there's a gather node? or other ways to get around?

A bit more detail on what are you trying to do exactly like what is
the query you or code you are dealing with, will be helpful in
providing suggestions,

--
Regards,
Rafia Sabih

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-04-26 14:51:36 Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6
Previous Message Ideriha, Takeshi 2019-04-26 14:50:00 RE: Copy data to DSA area