My RPM install didn't set pl/pgsql too... I needed to write this code :
Execute psql template1
After this, type these 2 lines :
CREATE FUNCTION plpgsql_call_handler () RETURNS opaque AS
'/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler
LANCOMPILER 'PL/PgSql internal';
----- Original Message -----
From: Marc Wrubleski <mlwruble@sorexsoftware.com>
To: <pgsql-general@postgresql.org>
Sent: Quarta-feira, 28 de Março de 2001 17:55
Subject: [GENERAL] enable pl/pgsql in postgres from postgres-server-7.0.3-2
RPM
: I installed Postgres from the 7.0.3-2 RPM on the Redhat site, and it
: works well, and the plpgsql.so library exists, but how do I enable this
: procedural language.
:
: I know how to do it from source, but my customer demands I install from
: RPM.
:
: Thanks in advance.
:
: Marc Wrubleski
:
:
: ---------------------------(end of broadcast)---------------------------
: TIP 6: Have you searched our list archives?
:
: http://www.postgresql.org/search.mpl
: