7.3.1 function problem: ERROR: cache lookup failed for type 0
От | Achilleus Mantzios |
---|---|
Тема | 7.3.1 function problem: ERROR: cache lookup failed for type 0 |
Дата | |
Msg-id | Pine.LNX.4.44.0301071943200.9521-100000@matrix.gatewaynet.com обсуждение исходный текст |
Ответ на | 7.3.1 index use / performance (Achilleus Mantzios <achill@matrix.gatewaynet.com>) |
Ответы |
Re: 7.3.1 function problem: ERROR: cache lookup failed for type 0
|
Список | pgsql-general |
Hi i had written a C function to easily convert an int4 to its equivalent 1x1 int4[] array. It worked fine under 7.1,7.2. Now under 7.3.1 i get the following message whenever i try to: dynacom=# select itoar(3126); ERROR: cache lookup failed for type 0 Surprisingly though when i do something like : dynacom=# select defid from machdefs where itoar(3126) ~ parents and level(parents) = 1 order by description,partno; defid ------- 3137 3127 3130 3129 3133 3136 3135 3128 3131 3132 3134 3138 (12 rows) it works fine, but then again when i try to EXPLAIN the above (successful) statement i also get: dynacom=# EXPLAIN select defid from machdefs where itoar(3126) ~ parents and level(parents) = 1 order by description,partno; ERROR: cache lookup failed for type 0 Any clues of what could be wrong?? The definition of the function is: CREATE FUNCTION "itoar" (integer) RETURNS integer[] AS '$libdir/itoar', 'itoar' LANGUAGE 'c' WITH ( iscachable,isstrict ); I also tried without the iscachable option with no luck (since it seems to complain about *type* 0) ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr
В списке pgsql-general по дате отправления: