But it does not mention TYPE. In the shippable.c/lookup_shippable() function, I found a comment that indicates that type is also pushed down. Hece, I have removed TYPE from the comments, assuming that it does not make sense to push down a data type, and only functions and operations can be pushed down. Please let me know if my assumption is incorrect. 🙂
On Tue, 2024-04-09 at 15:49 +0530, Rajan Pandey wrote: > I was reading https://www.postgresql.org/docs/current/postgres-fdw.html#POSTGRES-FDW-OPTIONS-REMOTE-EXECUTION > and found that it mentions that Immutable Functions and Operators can > be pushed down using `extensions` option for foreign server. > > But it does not mention about TYPE. In the shippable.c/lookup_shippable() > function, I found that type is also pushed down.
The comment only says that data types may be shippable, but not that they are actually shipped. Can you think of a case where a data type would be shipped to a foreign server? I wrote a foreign data wrapper, and I cannot think of such a case.
Perhaps the function comment should be adjusted by removing the parenthesis or changing it to "(operator/function/...)".
> Does this require updating the docs? Can I raise a PR to do so? Thank you! :)
You would send a patch against the "master" branch to the pgsql-docs list for that.