| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Unrecognized language plpgsql when CREATE FUNCTION?! |
| Date: | 2001-02-05 23:30:40 |
| Message-ID: | Pine.BSF.4.21.0102051529010.39272-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
You probably need to run createlang (createlang plpgsql databasename)
On Wed, 31 Jan 2001, Raymond Chui wrote:
> I have install all latest PostgreSQL 7.0.3 packages except python
> into my Redhat Linux 6.2
>
> When I CREATE FUNCTION fname() RETURN OPAQUE AS '
> DECLARE
> ...;
> BEGIN
> ....;
> END;
> ' LANGUAGE 'plpgsql';
>
> I got Unrecognized language plpgsql, it only recognized sql, C, internal
> and
> created_procedure_name.
> Well, in Postgres documents has examples for Language plpgsql.
> Please tell me what do I missing, what other packages I need to install?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R9Pilot | 2001-02-05 23:56:53 | [JDBC][INTERFACES][NOVICE] Postgresql inteface to Star Office using JDBC |
| Previous Message | Oliver Elphick | 2001-02-05 23:26:43 | Revised Debian packages for PostgreSQL 7.1beta4 |