Skip site navigation (1) Skip section navigation (2)

RE: need solution for cachelookupfailed error

From: "Darren King" <darrenk(at)insightdist(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Cc: "Kiran Patel" <k(dot)patel(at)i-engineering(dot)com>
Subject: RE: need solution for cachelookupfailed error
Date: 2001-03-22 17:18:31
Message-ID: NDBBJNEIGLIPLCHCMANLMEDGCLAA.darrenk@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-bugs
> 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



In response to

pgsql-bugs by date

Next:From: BLON S├ębastienDate: 2001-03-22 18:00:12
Subject: bug with identd autentication
Previous:From: Tom LaneDate: 2001-03-22 17:02:19
Subject: Re: Tests randomly failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group