Re: psql , stored procedure, triggers and errors

Penguin <Mail(at)dempos(dot)com> writes:
> I have added support of procedural language 'plpgsql' in
> postgres system table pg_language. Now when I try to insert a record
> in the emp table :

> insert into emp(empname, salary) values( 'test', 1000 );

> from psql I get the following error :

> psql:rec.sql:1:ERROR:frmgr_info:function 0:cache lookup failed

I copied-and-pasted your example, and it works fine for me on 7.0.*:

play=> insert into emp(empname, salary) values( 'test', 1000 );
INSERT 4576610 1
play=> insert into emp(empname, salary) values( 'test', -1);
ERROR: test cannot have a negative salary

I suspect you messed up the installation of 'plpgsql' somehow.
Did you use the createlang script for that, or do it by hand?

regards, tom lane