Re: [GENERAL] Re: unrecognized language plpgsql

2001-04-04 Thread Oliver Elphick
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

[GENERAL] Re: unrecognized language plpgsql

2001-04-04 Thread J.H.M. Dassen (Ray)
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

[GENERAL] Re: Unrecognized language plpgsql when CREATE FUNCTION?!

2001-02-05 Thread Raymond Chui
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