Skip site navigation (1) Skip section navigation (2)

problem in executing a function

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 (view raw or flat)
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



pgsql-novice by date

Next:From: Josh BerkusDate: 2002-02-14 21:31:48
Subject: Re: New ID
Previous:From: arifin purbaDate: 2002-02-14 12:05:05
Subject: Re: Peer authentication problem in CGI-Perl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group