From: | digoal(at)126(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6708: pgsql_fdw's foreign table cann't used in plpgsql function |
Date: | 2012-06-27 00:02:53 |
Message-ID: | E1Sjfif-0008SV-9N@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6708
Logged by: digoal.zhou
Email address: digoal(at)126(dot)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(at)126/blog/static/16387704020125218171919/
thanks very much;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-06-27 03:51:14 | Re: BUG #6707: ERROR: could not open relation with OID |
Previous Message | Jimmy Creeks | 2012-06-26 20:31:41 | Re: BUG #6705: 32 bit |