On your linux box
login as postgres
run
createlang [connection-options...] plpgsql [dbname]
should do the trick
http://www.pgexplorer.com
----- Original Message -----
From: <lexx_h@chat.ru>
To: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, May 07, 2002 10:53 AM
Subject: [INTERFACES]
> Hello all./
>
> Pls, help.
> How can I use PL/pgSQL (SQL Procedural Language) ?
> Because now I've got following error:
>
> ERROR: Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'.
> Recognized languages are sql, C, internal, and created procedural
> languages.
>
>
> WBR,lexx .
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>