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 ? Regards, Patrick Fiche Database Engineer, Aqsacom Sas. c. 33 6 82 80 69 96 -----Original Message----- From: Patrick FICHE <Patrick.Fiche@xxxxxxxxxxx> Sent: Friday, October 18, 2019 2:35 PM To: Tom Lane <tgl@xxxxxxxxxxxxx>; Guillaume Lelarge <guillaume@xxxxxxxxxxxx> Cc: pgsql-generallists.postgresql.org <pgsql-general@xxxxxxxxxxxxxxxxxxxx> Subject: RE: Execute a function through fdw Thanks a lot for your answer. Using a view is really a good solution for my case. As I already use fdw for some other cases, I prefer not to mix with dblink. Regards, Patrick Fiche -----Original Message----- From: Tom Lane <tgl@xxxxxxxxxxxxx> Sent: Friday, October 18, 2019 1:55 PM To: Guillaume Lelarge <guillaume@xxxxxxxxxxxx> Cc: Patrick FICHE <Patrick.Fiche@xxxxxxxxxxx>; pgsql-generallists.postgresql.org <pgsql-general@xxxxxxxxxxxxxxxxxxxx> Subject: Re: Execute a function through fdw Guillaume Lelarge <guillaume@xxxxxxxxxxxx> writes: > Le ven. 18 oct. 2019 à 11:51, Patrick FICHE > <Patrick.Fiche@xxxxxxxxxxx> a écrit : >> Is it possible to execute a function located on a server accessed >> through Postgres fdw. > It's probably easier to create a view on the remote server, and access > it as a foreign table on the local server. Yeah. Or if you really want to call a remote function by name, see dblink. postgres_fdw actively avoids doing that sort of thing. regards, tom lane
