Postgres Pro
Downloads
Home   >   mailing lists

Re: Execute a function through fdw - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Execute a function through fdw
Date
Msg-id CAECtzeWVP0DbDRGEe4=LMrx_BwvB_GR_vs39d7ueyWyArJk41Q@mail.gmail.com
Whole thread Raw
In response to RE: Execute a function through fdw  (Patrick FICHE <Patrick.Fiche@aqsacom.com>)
Responses RE: Execute a function through fdw
List pgsql-general
Tree view
Le ven. 18 oct. 2019 à 17:53, Patrick FICHE <Patrick.Fiche@aqsacom.com> a écrit :
Hi,

I got one more issue after I created my view.

I created it on my Server 1 but I am unable to view it on the Server 2.
I can see all tables through fdw after IMPORT FOREIGN SCHEMA.

I was able to get access to my view only after recreating the SERVER / USER MAPPING on Server 2.

Is it the expected behavior to recreate the FOREIGN SERVER / SCHEMA after a new table or view has been created ?

No, you don't need to re create the foreign server. How did it not work?

pgsql-general by date:

Previous
From: Patrick FICHE
Date:
Subject: RE: Execute a function through fdw
Next
From: Patrick FICHE
Date:
Subject: RE: Execute a function through fdw