I have the following table in PostgreSQL
CREATE TABLE idempiere.tbl_test
ALTER TABLE idempiere.tbl_test
OWNER TO postgres;
when I try to run the following sql script on it, it returns an error:
update tbl_test set val=val+10;
[Err] ERROR: cache lookup failed for procedure 0
I tested it with another schema in the same database and it worked. My problem is that this schema has many tables and functions.
I created a new schema and tested with my test table, but after restoring dump file
it's not working again.
How can I fix this?