problem in executing a function - Mailing list pgsql-novice

From Ivan Horvath
Subject problem in executing a function
Date
Msg-id 20020215094426.56695.qmail@web14707.mail.yahoo.com
Whole thread Raw
Responses Re: problem in executing a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi All,

my problem is the following
i created a function the code is the following:
CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
    BEGIN
        RETURN $1 + 1;
    END;
' LANGUAGE 'plpgsql';
the code is not so complicated, i do not have any
problem with this.

the problem is coming when i want to execute this
function
i give a command:
select add_one(1);
and i receive an error message, that
SearchSysCache: Bad cache id 27

when i tried on teh other computer the function is
working

i'm using pgsql 7.2 version on win2k operating system
with cygwin 1.3.2

please help me

thanks
Ivan



__________________________________________________
Do You Yahoo!?
Got something to say? Say it better with Yahoo! Video Mail
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: "Rob Arnold"
Date:
Subject: Re: Function Hangs
Next
From: "Patrick Hatcher"
Date:
Subject: column length and case sensitivity