From: | Ivan Horvath <pillesoft(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | problem in executing a function |
Date: | 2002-02-15 09:44:26 |
Message-ID: | 20020215094426.56695.qmail@web14707.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Hatcher | 2002-02-15 12:29:39 | column length and case sensitivity |
Previous Message | Rob Arnold | 2002-02-15 03:44:06 | Re: Function Hangs |