create and run a plpgsql function in postgresql

[Johan Ur Riise <riise@bgnett.no>]

This is Debian Woody.

Package: postgresql Version: 6.5.3-12
Package: postgresql-pl Version: 6.5.3-12

I can't get the functions in plpgsql to work. Is it a Debian
problem, a postgresql problem or is it a beginner error from my
part? Details:

First I  try to create and run a simple function:
tstlang=> create function en() returns int as '
tstlang'> begin return 1; end;
tstlang'> ' language 'plpgsql';
CREATE
tstlang=> select en() as result;
ERROR:  stat failed on file '@expanded_libdir@/plpgsql@DLSUFFIX@': No such file or directory
tstlang=> \q
postgres@egg:~$ 

i notice that function plpgsql_call_handler() is suspiciously  
defined as:
@expanded_libdir@/plpgsql@DLSUFFIX@

with locate i found the library in
/usr/lib/postgresql/lib/plpgsql.so

I tried to change the function 


tstlang=> drop function plpgsql_call_handler();
DROP
tstlang=> CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
tstlang-> '/usr/lib/postgresql/lib/plpgsql.so' LANGUAGE 'C';
CREATE

After that, I get..


tstlang=> select en() as result;
ERROR:  fmgr_info: function 18496: cache lookup failed
tstlang=> 

If I drop and recreate the function after this, I get the same
error including the same number(18496)

Any ideas?

Johan Ur Riise