Thread: BUG #6478: Foreign tables not displayed

BUG #6478: Foreign tables not displayed

From
roman@chmela.sk
Date:
The following bug has been logged on the website:

Bug reference:      6478
Logged by:          Roman Chmela
Email address:      roman@chmela.sk
PostgreSQL version: 9.1.2
Operating system:   1) Windows 7 pro, 2) Ubuntu
Description:=20=20=20=20=20=20=20=20

Hello
I have setup successfully foreign table, fully functional, retrieving data
from external csv file:
create extension file_fdw;
CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw;

CREATE FOREIGN TABLE my_names (
    name text,
    surname text
) SERVER file_server
OPTIONS (format 'text', filename 'c:\xxx\my_names.csv', delimiter ';', null
'');

-----------------
Problem:
-----------------
- this table is not listed among tables (using pgadmin)

-------------------
Possible solution?
-------------------
CREATE OR REPLACE VIEW pg_tables AS=20
 SELECT n.nspname AS schemaname, c.relname AS tablename,
pg_get_userbyid(c.relowner) AS tableowner, t.spcname AS tablespace,
c.relhasindex AS hasindexes, c.relhasrules AS hasrules, c.relhastriggers AS
hastriggers
   FROM pg_class c
   LEFT JOIN pg_namespace n ON n.oid =3D c.relnamespace
   LEFT JOIN pg_tablespace t ON t.oid =3D c.reltablespace
  --WHERE c.relkind =3D 'r'::"char";
  WHERE c.relkind in ('r'::"char",'f'::"char");

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Thank you for response
Regards
Roman Chmela

Re: BUG #6478: Foreign tables not displayed

From
Guillaume Lelarge
Date:
On Mon, 20 Feb 2012 16:32:27 +0000, roman@chmela.sk wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6478
> Logged by:          Roman Chmela
> Email address:      roman@chmela.sk
> PostgreSQL version: 9.1.2
> Operating system:   1) Windows 7 pro, 2) Ubuntu
> Description:
>
> Hello
> I have setup successfully foreign table, fully functional, retrieving
data
> from external csv file:
> create extension file_fdw;
> CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw;
>
> CREATE FOREIGN TABLE my_names (
>     name text,
>     surname text
> ) SERVER file_server
> OPTIONS (format 'text', filename 'c:\xxx\my_names.csv', delimiter ';',
null
> '');
>
> -----------------
> Problem:
> -----------------
> - this table is not listed among tables (using pgadmin)
>
> -------------------
> Possible solution?
> -------------------
> CREATE OR REPLACE VIEW pg_tables AS
>  SELECT n.nspname AS schemaname, c.relname AS tablename,
> pg_get_userbyid(c.relowner) AS tableowner, t.spcname AS tablespace,
> c.relhasindex AS hasindexes, c.relhasrules AS hasrules, c.relhastriggers
AS
> hastriggers
>    FROM pg_class c
>    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
>    LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
>   --WHERE c.relkind = 'r'::"char";
>   WHERE c.relkind in ('r'::"char",'f'::"char");
>

Foreign tables have their own node. This node is not displayed by default.
You need to go the preferences dialog, select the Browser tab, and check
the "Foreign tables" checkbox. And reconnect to your server. That should
display a new node with all foreign tables.

BTW, if you find bugs or have issues with pgadmin, you shouldn't send them
here. Use the pgadmin-support mailing list instead.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com