Thread:

From
lexx_h@chat.ru
Date:
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 .


Re:

From
"PGMailList"
Date:
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)
>