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: (view raw, whole thread or download thread mbox)
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
> '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('','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.


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-2017 The PostgreSQL Global Development Group