Re: enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM

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
: