Re: Execute INSERT during a parallel operation - Mailing list pgsql-hackers

From Rafia Sabih
Subject Re: Execute INSERT during a parallel operation
Date
Msg-id CA+FpmFfgGsYTdva=jXoDi-FV34W0REZk2eV_YD00nSAMosd+aQ@mail.gmail.com
Whole thread Raw
In response to Execute INSERT during a parallel operation  (Donald Dong <xdong@csumb.edu>)
List pgsql-hackers
On Sun, 14 Apr 2019 at 04:11, Donald Dong <xdong@csumb.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
insertoperations 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



pgsql-hackers by date:

Previous
From: "Ideriha, Takeshi"
Date:
Subject: RE: Copy data to DSA area
Next
From: Tom Lane
Date:
Subject: Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6