Re: unrecognized language 'plpgsql' - Mailing list pgsql-sql

From Richard Huxton
Subject Re: unrecognized language 'plpgsql'
Date
Msg-id 009001c0f970$22054d00$1001a8c0@archonet.com
Whole thread Raw
In response to unrecognized language 'plpgsql'  (Markus Wagner <wagner@imsd.uni-mainz.de>)
List pgsql-sql
From: "Markus Wagner" <wagner@imsd.uni-mainz.de>

> Hi,
>
> when creating a function I get the error message 'unrecognized
> language'.
> What's this? I need a powerful language which can retrieve many things
> (username, tables, attributes, etc.).
> Isn't plpgsql the best choice? Why this message and where can I find
> more documentation on plpgsql?

Try "man createlang" - you need to turn a language on for each database that
needs it.

The docs for plpgsql have been much updated in the 7.1 docs and there are
some useful examples in Roberto Mello's cookbook at
techdocs.postgresql.org - there is a host of other stuff there too including
some examples of trigger usage in my "postgresql notes".

- Richard Huxton



pgsql-sql by date:

Previous
From: Markus Wagner
Date:
Subject: unrecognized language 'plpgsql'
Next
From: "Richard Huxton"
Date:
Subject: Re: log file