J.H.M. Dassen (Ray) wrote:
>DaVinci <[EMAIL PROTECTED]> wrote:
>>ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
>
>> I use Debian packages for Pg 7.1 BETA4. I thought plpgsql was integrated b
>y
>> default, but see it is not so.
>
>I have the same p
DaVinci <[EMAIL PROTECTED]> wrote:
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> I use Debian packages for Pg 7.1 BETA4. I thought plpgsql was integrated by
> default, but see it is not so.
I have the same problem with 7.1RC2 built using Oliver's Debian diff f
Be default PL/PGSQL is not installed in each database. You must type
createlang --host=hostname --port=5432 --username=postgres --dbname=yourdb
--pglib=$PGLIB plpgsql yourdb
To verify type
createlang -l yourdb
--Raymond
begin:vcard
n:Chui;Raymond
tel;fax:(301)713-0963
tel;home:ICQ #: 16722