Re: postgres_fdw has insufficient support for large object

On Sunday, May 22, 2022, Saladin <jiaoshuntian(at)highgo(dot)com> wrote:

>
> The output i expected:
> pg_largeobject_metadata and pg_largeobject in both database A and database
> B should have rows.Shouldn't only in database A.So, i can use large object
> functions
> to operate large_objectin remote table or foreign table.
>

This is an off-topic email for the -hackers mailing list. -general is the
appropriate list.

Your expectation is simply unsupported by anything in the documentation.

If you want to do what you say you will need to use dblink (and the file
needs to be accessible to the remote server directly) and directly execute
entire queries on the remote server, the FDW infrastructure simply does not
work in the way you are expecting.

Or just use bytea.

David J.