Re: A question

That error comes from the server, and usually means that a function being called doesn't exist any more. I didn't think PostgreSQL 7.2 could return sets from a function though?

Regards, Dave.

> -----Original Message-----
> From: sunthing(at)963(dot)net [mailto:sunthing(at)963(dot)net]
> Sent: 28 November 2002 05:27
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] A question
>
>
> My postgresql version is 7.2.1
> I have create a function:
> create function returnset(varchar) returns setofcomputers
> as '
> select * from computer where hostname like ''%''+$1+''%'' '
> language 'plpgsql';
>
> But when I select returnset('aaa') ,it returns:
>
> An error has occured in pgAdmin
> II:frmSQLInput.cmdExecute_Click:
> Number:-2147467259
> Description:ERROR:fmgr_info:function 0:cache lookup failed
>
> Please tell me what means!
> ____________________________________________________________
>
> 欢迎使用963免费邮局(http://www.szonline.net)
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your message can get through
> to the mailing list cleanly
>