pgadmin not displaying data from postgresql_fdw

From: Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)com>
To: <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: pgadmin not displaying data from postgresql_fdw
Date: 2018-08-28 15:37:04
Message-ID: 5b856c24.1c69fb81.ab35a.ce0a@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

When doing some testing about postgresql_fdw extension to connect local and
remote databases, I was surprised to notice that the local connected schema
seems to have no table in pgadmin 3 or pgadmin 4 trees.

Those commands ran fine :

CREATE SERVER fdw _prod01 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host
'localhost', dbname '_prod01', port '5433');

CREATE USER MAPPING FOR postgres SERVER fdw_prod01 OPTIONS (user 'postgres',
password '');

CREATE SCHEMA fdw_prod01a;

IMPORT FOREIGN SCHEMA pre_prod FROM SERVER fdw_prod01 INTO fdw_prod01a;

It's then possible to apply select, insert or delete commands on fdw_prod01a
schema. Going to the 'remote' database shows inserted data into pre_prod
schema.

this command returns tables list from local fdw_prod01a :

SELECT distinct table_schema,table_name FROM information_schema.TABLES where
table_schema = 'fdw_prod01a'

So everything seems fine, except the pgadmin tree which does not display any
table under the fdw_prod01 branch, even if it's possible to query it's
tables with sql.

Did I forget something ? Is that a bug ? Does postgresql_fdw store
informations in such a way that pgadmin is not able to get them, even when
they exists in pg tables ?

Thanks for any answer,

Olivier

Browse pgsql-sql by date

  From Date Subject
Next Message Olivier Leprêtre 2018-08-29 13:48:36 redundant constraint_schema
Previous Message Huan Ruan 2018-08-06 06:15:30 Re: read explain (analyse, buffers) output in Postgres 10.4 with parallel on