Thread: PL/pgSQL

How does one compile or add PL/pgSQL if it doesn't already exist?

I've searched the DOCS and mailing list and the best that I can come up
with is an enable script that complains about the missing .sql file.

I'm running 6.4.2

Thanks in advance.

Andy

Andy Lewis ha scritto:

> How does one compile or add PL/pgSQL if it doesn't already exist?
>
> I've searched the DOCS and mailing list and the best that I can come up
> with is an enable script that complains about the missing .sql file.
>
> I'm running 6.4.2

cd postgresql-v6.4.2/src/pl/plpgsql
and run:
make clean
make all
make install
to compile and install plpgsql.so
then
create language by:
cd postgresql-v6.4.2/src/pl/plpgsql/src
psql < mklang.sql

José

Thanks I'll give it a try!

Andy

On Tue, 27 Apr 1999, [iso-8859-1] Jos� Soares wrote:

>
>
> Andy Lewis ha scritto:
>
> > How does one compile or add PL/pgSQL if it doesn't already exist?
> >
> > I've searched the DOCS and mailing list and the best that I can come up
> > with is an enable script that complains about the missing .sql file.
> >
> > I'm running 6.4.2
>
> cd postgresql-v6.4.2/src/pl/plpgsql
> and run:
> make clean
> make all
> make install
> to compile and install plpgsql.so
> then
> create language by:
> cd postgresql-v6.4.2/src/pl/plpgsql/src
> psql < mklang.sql
>
> Jos�
>
>
>