Re: store procedure in pl/pgsql

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: Juan Ramón Cortabitarte <jcorta(at)tribctas(dot)gba(dot)gov(dot)ar>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: store procedure in pl/pgsql
Date: 2001-02-28 14:15:02
Message-ID: 003201c0a191$0d8dcaa0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Juan Ramón Cortabitarte" <jcorta(at)tribctas(dot)gba(dot)gov(dot)ar>

> Error: ERROR: Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'. Recognized languages are sql, C, internal and the created
> procedural languages.
>
> I´m using Red Hat Linux 7.0 and Postgress 7.02.
> i executed:
>
> #createlang plpgsql dbhtc

Try doing this as user postgres rather than root - that's why it can't see
PGLIB environment var.

> createlang: missing required argument PGLIB directory
> (This is the directory where the interpreter for the procedural
> language is stored. Traditionally, these are installed in whatever
> 'lib' directory was specified at configure time.)

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Renaud Tthonnart 2001-02-28 14:15:16 Re: array containing references
Previous Message hubert depesz lubaczewski 2001-02-28 13:54:45 strange error