pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
unrecognized 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