Re: BUG #6478: Foreign tables not displayed

On Mon, 20 Feb 2012 16:32:27 +0000, roman(at)chmela(dot)sk wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6478
> Logged by: Roman Chmela
> Email address: roman(at)chmela(dot)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