Re: [GENERAL] PL/pgSQL - Mailing list pgsql-general

From José Soares
Subject Re: [GENERAL] PL/pgSQL
Date
Msg-id 3725B6FC.2F58E4C@sferacarta.com
Whole thread Raw
In response to PL/pgSQL  (Andy Lewis <alewis@themecca.net>)
Responses Re: [GENERAL] PL/pgSQL  (Andy Lewis <alewis@themecca.net>)
List pgsql-general

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é



pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [GENERAL] advice on buying sun hardware to run postgres
Next
From: JP Rosevear
Date:
Subject: Re: [GENERAL] unknown symbol 'lo_unlink'