Re: FDW Foreign Table Access: strange LOG message
От | Albrecht Dreß |
---|---|
Тема | Re: FDW Foreign Table Access: strange LOG message |
Дата | |
Msg-id | TOZ7CDTG.CKNCALXH.G2HBWRGB@QH4JFHO3.57A75GMV.CF3QRUD7 обсуждение исходный текст |
Ответ на | Re: FDW Foreign Table Access: strange LOG message (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: FDW Foreign Table Access: strange LOG message
Re: FDW Foreign Table Access: strange LOG message |
Список | pgsql-general |
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 thecommand above, the LOG message appears. It does not appear when I query tables from my_db exclusively, though, i.e. whenI 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@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 installedproperly. > 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.
Вложения
В списке pgsql-general по дате отправления: