Re: FDW Foreign Table Access: strange LOG message

Hi Adrian:

Am 21.03.18 19:25 schrieb(en) Adrian Klaver:
> Does it also happen when you open a psql session and do?:
>
> psql>select * from ext_table limit 1;

No messages are printed whilst the session is open. However, when I quit the session by typing “\q” /after/ entering the command above, the LOG message appears. It does not appear when I query tables from my_db exclusively, though, i.e. when I do not access the Foreign Table.

>> postgresql-10            10.3-1.pgdg90+1 amd64
>> postgresql-client-10     10.3-1.pgdg90+1 amd64
>> postgresql-client-common 190.pgdg90+1    all
>> postgresql-common        190.pgdg90+1    all
>> libpq5:amd64             10.3-1.pgdg90+1 amd64
>
> I am not seeing --contrib which is where I would expect postgres_fdw to come from.

Apparently, it is packaged with the main server deb file:

albrecht(at)odysseus:~$ dpkg -S $(find /usr/share/postgresql -name "*fdw*")
postgresql-10: /usr/share/postgresql/10/extension/file_fdw--1.0.sql
postgresql-10: /usr/share/postgresql/10/extension/file_fdw.control
postgresql-10: /usr/share/postgresql/10/extension/postgres_fdw--1.0.sql
postgresql-10: /usr/share/postgresql/10/extension/postgres_fdw.control

…and additionally it contains /usr/lib/postgresql/10/postgres_fdw.so, of course. I double-checked the package http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-10/postgresql-10_10.3-1.pgdg90+1_amd64.deb; it is installed properly.

> Is --contrib installed?

No. But the deb file postgresql-contrib_10+190.pgdg90+1_all.deb contains only the changelog and copyright files.

> If not where is postgres_fdw coming from?

See above…

Cheers,
Albrecht.