Обсуждение: problem in executing a function

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

Ivan Horvath <pillesoft@yahoo.co.uk> writes:
> SearchSysCache: Bad cache id 27

I will bet that your plpgsql.so file is out of date, or the new
installation is still pointing at the old file.

            regards, tom lane

thank you very much, but it is working

Ivan

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Ivan Horvath <pillesoft@yahoo.co.uk> writes:
> > SearchSysCache: Bad cache id 27
>
> I will bet that your plpgsql.so file is out of date,
> or the new
> installation is still pointing at the old file.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com