Re: How to properly use the Executor interface? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to properly use the Executor interface?
Date
Msg-id 10818.1541446938@sss.pgh.pa.us
Whole thread Raw
In response to How to properly use the Executor interface?  (Kai Kratz <kai.kratz@swarm64.com>)
List pgsql-hackers
Kai Kratz <kai.kratz@swarm64.com> writes:
> first time writing to the hackers list, so I hope this is the right place to ask. I recently joined Swarm64 and we
arebuilding a postgres extension with the fdw interface. 

> I am trying to evaluate sql statements with ExecutorBeing, -Run, -End, -Finish calls during ExecForeignInsert.

This seems ... uh ... really bizarre.  Why would you want an FDW to push
actions back into the executor?  I'm having a hard time envisioning
use-cases that wouldn't be better handled by, say, updatable views.

Anyway, you might be better off to go through SPI rather than try to call
the executor directly.  It's better documented and we try to avoid
breaking those APIs, whereas the core executor APIs change regularly.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Getting ERROR: could not open file "base/13164/t3_16388" withpartition table with ON COMMIT
Next
From: Andres Freund
Date:
Subject: Re: Reduce maintenance burden of alternative output files with \if\quit