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
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 |