Re: [GENERAL] PL/pgSQL

[Jos� Soares]

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�