| From: | Ivan Horvath <i(dot)horvath(at)alco(dot)co(dot)hu> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | problem in executing a function |
| Date: | 2002-02-14 15:58:43 |
| Message-ID: | 00d501c1b570$7a432570$3301a8c0@ivan |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-02-14 21:31:48 | Re: New ID |
| Previous Message | arifin purba | 2002-02-14 12:05:05 | Re: Peer authentication problem in CGI-Perl |