Обсуждение: Execute INSERT during a parallel operation

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?

Thank you,
Donald Dong

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