Re: [GENERAL] Oracle_FDW - Cache lookup failed

[Albe Laurenz]

Emanuel Araújo wrote:
> I have a problem wiht Oracle FDW 0.9.10 in PostgreSQL 9.3
> 
> I am using pg 9.3.4
> 
> Oracle FDW 0.9.10
> 
> Fedora 20
> 
> Client Oracle Release 11.2.0.3.0
> 
> 
> Return Error:
> 
> ERROR:  cache lookup failed for type 0

This is a known bug, the fix is already committed:
https://github.com/laurenz/oracle_fdw/commit/9e0a421b16e542c5caf9734a923e87f050cdbefd

I plan to release a new version soon since this has already hit several people.

Yours,
Laurenz Albe

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Oracle_FDW - Cache lookup failed

[Emanuel Araújo]

Hi,

I have a problem wiht Oracle FDW 0.9.10 in PostgreSQL 9.3
I am using pg 9.3.4
Oracle FDW 0.9.10
Fedora 20
Client Oracle Release 11.2.0.3.0

Return Error:

ERROR:  cache lookup failed for type 0

I am executing the simple query in most foreign tables..

Example wher tables with f_ are foreign tables:


SELECT 0 AS u_pkey,
   f_vendedor.u_orgvendaAS u_orgvenda,
   f_vendedor.s_codvendedor AS s_codvendedor,
   grupos.s_codgrupoAS s_codgrupo,
   f_produto.s_codproduto
  FROM f_vendedor
  JOIN (SELECT 'D'AS s_tipogrupo,
   codepto::text  AS s_codgrupo,
   codusur::text  AS s_codvendedor
 FROM erp.pcusurdepsec
UNION
SELECT DISTINCT
   'D'AS s_tipogrupo,
   codepto::text  AS s_codgrupo,
   codusur::text  AS s_codvendedor
 FROM f_vendedor CROSS JOIN (SELECT DISTINCT codepto FROM
f_produto) f_produto
UNION ALL
SELECT DISTINCT
   'S'AS s_tipogrupo,
   codsec::text   AS s_codgrupo,
   codusur::text  AS s_codvendedor
 FROM erp.pcusurdepsec
UNION
SELECT DISTINCT
   'S'AS s_tipogrupo,
   codsec::text   AS s_codgrupo,
   codusur::text  AS s_codvendedor
 FROM f_vendedor CROSS JOIN (SELECT DISTINCT codsec FROM f_produto)
f_produto
UNION ALL
SELECT 'F' AS s_tipogrupo,
   codfornec::text AS s_codgrupo,
   codusur::text   AS s_codvendedor
 FROM erp.pcusurfornec
UNION
SELECT DISTINCT
   'F'  AS s_tipogrupo,
   codfornec::text  AS s_codgrupo,
   codusur::textAS s_codvendedor
 FROM f_vendedor CROSS JOIN (SELECT DISTINCT codfornec FROM
f_produto) f_produto
UNION ALL
SELECT DISTINCT
   'I'::textAS s_tipogrupo,
   pcdistrib.coddistrib AS s_codgrupo,
   f_vendedor.s_codvendedor AS s_codvendedor
  FROM erp.pcdistrib
 CROSS JOIN f_vendedor
) grupos ON (f_vendedor.s_codvendedor = grupos.s_codvendedor)
  INNER JOIN t_vendedor ON (t_vendedor.s_codigo = f_vendedor.s_codvendedor
AND t_vendedor.u_bloqueado = 0)
  INNER JOIN f_produto ON ( grupos.s_codgrupo = (CASE WHEN (SELECT s_valor
FROM t_parametro_cliente WHERE s_campo = 'v_utiliza_grupo') = 'D' THEN
f_produto.codepto::text
  WHEN (SELECT s_valor
FROM t_parametro_cliente WHERE s_campo = 'v_utiliza_grupo') = 'F' THEN
f_produto.codfornec::text
  WHEN (SELECT s_valor
FROM t_parametro_cliente WHERE s_campo = 'v_utiliza_grupo') = 'S' THEN
f_produto.codsec::text
  WHEN (SELECT s_valor
FROM t_parametro_cliente WHERE s_campo = 'v_utiliza_grupo') = 'I' THEN
f_produto.coddistrib::text
 END) )
  WHERE grupos.s_tipogrupo = (SELECT s_valor
 FROM t_parametro_cliente
WHERE s_campo = 'v_utiliza_grupo')
  ;






-- 


*Atenciosamente,Emanuel Araújo*

*Linux Certified, DBA PostgreSQL*