On Tue, 2026-03-03 at 10:19 -0800, Masahiko Sawada wrote:
> It made me think that it might be
> interesting to implement a FDW that supports only the libpq
> connection
> (i.e., NO HANDLER, NO VALIDATOR, and CONNECTION) as it provides the
> connection management capability useful for subscriptions while users
> can avoid any security risks in postgres_fdw that users might be
> concerned about.
We discussed some similar ideas earlier in the thread. My initial
proposal used special "FOR CONNECTION ONLY" syntax and had special
cases for the FDW.
Tom didn't like the special syntax and catalog work[1], and suggested a
dummy FDW. Ashutosh expressed concern about the scope of a dummy
FDW[2], and suggested that we just rely on postgres_fdw, which is the
current patch. I agree and think it's the right direction.
A new special-purpose FDW might be useful, but I don't understand the
exact use case yet, so I think it's better to leave it to the user to
implement a new FDW that does what they want. (Perhaps special safety
rules, etc.)
Regards,
Jeff Davis
[1]
https://www.postgresql.org/message-id/172273.1693403385%40sss.pgh.pa.us
[2]
https://www.postgresql.org/message-id/caexhw5uczs-vesyqhthxfsdqik-f_o892xmzrzm2fuo+ro+...@mail.gmail.com
