Cache lookup error

From: Juan Francisco Diaz <j-diaz(at)publicar(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Cache lookup error
Date: 2003-09-25 15:08:18
Message-ID: BB986F12.C42%j-diaz@publicar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi i keep getting this error but i definitely dont understand or know how to
correct it...

SELECT * FROM BUSCabLista('0', '000081');
ERROR: cache lookup for type 0 of cabezalista.........pg.dropped.41........
failed
WARNING: plpgsql: ERROR during compile of buscablista near line 0
WARNING: plpgsql: ERROR during compile of buscablista near line 0
ERROR: cache lookup for type 0 of cabezalista.........pg.dropped.41........
Failed

The function looks like this:

DECLARE
                Codigo ALIAS FOR $1;
                Libro ALIAS FOR $2;
                res cabezalista%ROWTYPE;
        BEGIN

                FOR res IN select * from cabezalista where idlista like CAST
(Codigo AS CHAR(20)) and idlibro like CAST(Libro AS CHAR(6)) LOOP
                        RETURN NEXT res;
                END LOOP;
                return;
        END;

Thnks!

JuanF

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Godshall Michael 2003-09-25 15:32:25 Calling a function within a function - plpsql
Previous Message Tom Lane 2003-09-25 13:31:26 Re: transaction log location