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

From Josh Berkus
Subject Re: unrecognized language 'plpgsql'
Date
Msg-id web-74536@davinci.ethosmedia.com
Whole thread Raw
In response to unrecognized language 'plpgsql'  (Markus Wagner <wagner@imsd.uni-mainz.de>)
List pgsql-sql
Mr. Wagner,

> 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?

Yes.  Roberto Mello has excellent extended docs for PL/pgSQL:
http://www.brasileiro.net/postgres/plpgsql/

Your issue is that PL/pgSQL has not yet been created in the database you
are using as an available function language.  Go to the regular online
user docs and look up "CREATE LANGUAGE" for instructions on how to do
this.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: log file
Next
From: Roberto Mello
Date:
Subject: Re: Re: [ADMIN] Row Level Locking !!