The following bug has been logged on the website: Bug reference: 6708 Logged by: digoal.zhou Email address: dig...@126.com PostgreSQL version: 9.1.3 Operating system: CentOS 5.x bit64 Description:
pgsql_fdw's foreign table "cache lookup failed for type 0" bug when used in function 1.INSTALL https://github.com/dvarrazzo/interdbconnect/downloads mv pgsql_fdw $PG_SRC/contrib/ cd $PG_SRC/contrib/pgsql_fdw . /home/postgres/.bash_profile USE_PGXS=1 make USE_PGXS=1 make install 2.TEST digoal=# create extension pgsql_fdw; CREATE EXTENSION CREATE SERVER srv_digoal FOREIGN DATA WRAPPER pgsql_fdw OPTIONS (host '172.16.3.33', port '5432', dbname 'digoal'); CREATE USER MAPPING FOR digoal SERVER srv_digoal OPTIONS (user 'rmt_digoal', password 'DIGOAL123'); grant usage on foreign server srv_digoal to digoal; \c digoal digoal CREATE FOREIGN TABLE test ( id int ) server srv_digoal options (nspname 'digoal', relname 'table_digoal'); select * from test; It can do success, and return currect rows; but , if test table in plpgsql function , then error occur: create or replace function f_test () returns int as $$ declare begin perform 1 from test limit 1; return 0; end; $$ language plpgsql; digoal=# \set VERBOSITY verbose digoal=# select * from f_test(); ERROR: XX000: cache lookup failed for type 0 CONTEXT: SQL statement "SELECT 1 from test limit 1" PL/pgSQL function "f_test" line 3 at PERFORM LOCATION: getTypeOutputInfo, lsyscache.c:2440 3. DETAIL information please visit my blog : http://blog.163.com/digoal@126/blog/static/16387704020125218171919/ thanks very much; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
