From: | Együd Csaba <csegyud(at)vnet(dot)hu> |
---|---|
To: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed |
Date: | 2003-12-30 12:11:44 |
Message-ID: | 004d01c3cece$17c1af60$230a0a0a@compaq |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I run into an error message.
I have the following function where t_stockchanges is one of my tables.
--------------------------------------------
create or replace function get_last_open(int, int) returns setof
t_stockchanges AS '
declare
ProductID alias for $1;
StockID alias for $2;
q text;
Rec t_stockchanges%ROWTYPE;
begin
q := ''select * from t_stockchanges where '' ||
''stockid='' || quote_literal(StockID) || '' and '' ||
''productid='' || quote_literal(ProductID) || '' and '' ||
''changeid=1 order by time desc limit 1;'';
for Rec in execute q loop
return next Rec;
end loop;
return;
end;'
language 'plpgsql';
--------------------------------------------
Running the following query I get the error message:
#> select * from get_last_open(140,1);
WARNING: plpgsql: ERROR during compile of get_last_open near line 5
ERROR: cache lookup for type 0 of
t_stockchanges.........pg.dropped.14........ failed
------
Could anybody tell me how can I work it around. A tried to restart the
server to make empty the cache, but it seems to be worthless.
Thank you in advance.
Bye,
-- Csaba Együd
From | Date | Subject | |
---|---|---|---|
Next Message | B. van Ouwerkerk | 2003-12-30 12:20:19 | Re: Is my MySQL Gaining ? |
Previous Message | B. van Ouwerkerk | 2003-12-30 11:50:21 | Re: Is my MySQL Gaining ? |