pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedunrecognized language 'plpgsql'
3+ messages / 3 participants
[nested] [flat]
* unrecognized language 'plpgsql'
@ 2001-06-20 05:27 Markus Wagner <wagner@imsd.uni-mainz.de>
0 siblings, 2 replies; 3+ messages in thread
From: Markus Wagner @ 2001-06-20 05:27 UTC (permalink / raw)
To: pgsql-sql
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?
Thank you,
Markus
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: unrecognized language 'plpgsql'
@ 2001-06-20 09:51 Richard Huxton <dev@archonet.com>
parent: Markus Wagner <wagner@imsd.uni-mainz.de>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2001-06-20 09:51 UTC (permalink / raw)
To: Markus Wagner <wagner@imsd.uni-mainz.de>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: unrecognized language 'plpgsql'
@ 2001-06-20 14:51 Josh Berkus <josh@agliodbs.com>
parent: Markus Wagner <wagner@imsd.uni-mainz.de>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2001-06-20 14:51 UTC (permalink / raw)
To: Markus Wagner <wagner@imsd.uni-mainz.de>; +Cc: 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 information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-06-20 14:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-20 05:27 unrecognized language 'plpgsql' Markus Wagner <wagner@imsd.uni-mainz.de>
2001-06-20 09:51 ` Richard Huxton <dev@archonet.com>
2001-06-20 14:51 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox