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

Marc Wrubleski <mlwruble@sorexsoftware.com> writes:

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.

All you have to do is run the 'createlang' script that comes with
Postgres (see the man page). If your customer wants this to be done
via RPM, well, that's possible (just make an RPM with no files and
postinstall/preremove scripts that do the appropriate commands).

Once 'createlang' is tun on the 'template1' database, all DBs created
after that will have your language(s) available.

-Doug

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
: