Thread

RE: need solution for cachelookupfailed error

Darren King <darrenk@insightdist.com> — 2001-03-22T17:18:31Z

> Company Table Structure
> create table company ( id serial PRIMARY KEY, comp_name varchar(100),
shortname varchar(20));
> Insert Function for company table
> create function insertcompany(varchar(100),varchar(20)) returns int4
as
> 'begin
>     Insert into company (comp_name,shortname) values ($1,$2);
>     return 0;
> end;' language 'plpgsql';
> Now If I run the above function from the psql command prompt with the
following syntax
>    select insertcompany('iengineering.com','eslab');

Have you tried explicitly casting the strings to varchar in the call to
insertcompany in the above select statement?

If the parser is treating them as something other than varchar, the
system would look for an insertcompany function those types for args.

darrenk