Re: Unrecognized language plpgsql when CREATE FUNCTION?!

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unrecognized language plpgsql when CREATE FUNCTION?!
Date: 2001-02-01 13:56:44
Message-ID: 3A796B1C.AAE9DD67@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Attachment Content-Type Size
raymond.chui.vcf text/x-vcard 421 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Lang 2001-02-01 14:22:08 Borland Kylix
Previous Message Mark Alliban 2001-02-01 13:31:41 Number of open files