Re: PG FDW query fails, works local, same credentials

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pete O'Such" <posuch(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PG FDW query fails, works local, same credentials
Date: 2023-08-31 04:46:28
Message-ID: 305861.1693457188@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Pete O'Such" <posuch(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2023-08-31 11:54:21 Re: event trigger clarification
Previous Message Pete O'Such 2023-08-31 03:52:35 PG FDW query fails, works local, same credentials