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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 28 November 2002 05:27 > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] so that your message can get through > to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
