问题描述:

I have the following table in PostgreSQL

CREATE TABLE idempiere.tbl_test

(

val numeric(10,0)

)

WITH (

OIDS=FALSE

);

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;

error:

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

相关阅读:
Top