Re: Accessing parameters of a prepared query inside an FDW

2024-02-17 Thread Adam Fletcher
On Wed, Feb 14, 2024 at 7:43 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, February 14, 2024, Adam Fletcher > wrote: >> >> >> Is it possible to get the parameterized prepared query inside an FDW such >> that it can be prepared/bind'd/execute'd on the receiving end of t

Re: Accessing parameters of a prepared query inside an FDW

2024-02-14 Thread David G. Johnston
On Wednesday, February 14, 2024, Adam Fletcher wrote: > > > Is it possible to get the parameterized prepared query inside an FDW such > that it can be prepared/bind'd/execute'd on the receiving end of the FDW? > > For example, if I `PREPARE stmt(int) AS SELECT * from fdwrapped_tbl where > pk = $1;

Accessing parameters of a prepared query inside an FDW

2024-02-14 Thread Adam Fletcher
Hi Folks, Is it possible to get the parameterized prepared query inside an FDW such that it can be prepared/bind'd/execute'd on the receiving end of the FDW? For example, if I `PREPARE stmt(int) AS SELECT * from fdwrapped_tbl where pk = $1;` then `execute stmt(1);` I want my FDW be aware that the