Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem in executing a function

problem in executing a function

From
Ivan Horvath
Date:
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

Re: problem in executing a function

From
Tom Lane
Date:
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

Re: problem in executing a function

From
Ivan Horvath
Date:
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