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 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
:
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
