[EMAIL PROTECTED] writes:
> though, even that results in "ERROR: Unrecognized language specified in a CREATE
>FUNCTION: 'pl-pgsql'. Recognized languages are sql, C, internal and
> the created procedural languages."
Uh, did you run the "createlang" script to install plpgsql into your
database?
did you install the procedural language correctly?
under RedHat, you have to do the following:
(the location of the handler is different because of
packaging conventions)
CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE TRUSTED P
Hi
You need to make the call_handler and create the language plpgsql.
Assuming postgres is installed in /usr/local/pgsql
Example:
-- Setup -- define the languages and the associated handlers
CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C
On Tue, 30 May 2000 [EMAIL PROTECTED] wrote:
> I am running PostgreSQL 6.5.3 on RedHat Linux 6.1 on a PC.
> I am trying to use Pg/PLSQL.
>
> I even tried being conservative enough to copy the example code from
> http://www.postgresql.org/docs/user/c40874340.htm as follows:
> CREATE FUNCTION add
I am running PostgreSQL 6.5.3 on RedHat Linux 6.1 on a PC.
I am trying to use Pg/PLSQL.
I even tried being conservative enough to copy the example code from
http://www.postgresql.org/docs/user/c40874340.htm as follows:
CREATE FUNCTION add_one (int4) RETURNS int4 AS '
BEGIN
RETURN $1 +
