"Pete O'Such" <pos...@gmail.com> writes: > I've got a view on server A (PG 15.2) that fails when queried via FDW from > server B (also PG 15.2). Querying it as a foreign table from server B > yields a message like "ERROR: function blah(type) does not exist".
Check your search path assumptions. postgres_fdw runs remote queries
with a very minimal search_path setting, so that unqualified references
to non-built-in objects are likely to fail.
regards, tom lane
