Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Marc Wrubleski
Date:
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

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

From
Doug McNaught
Date:
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

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

From
"Vilson farias"
Date:
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
: