Re: store procedure in pl/pgsql - Mailing list pgsql-general

From Richard Huxton
Subject Re: store procedure in pl/pgsql
Date
Msg-id 003201c0a191$0d8dcaa0$1001a8c0@archonet.com
Whole thread Raw
In response to last UPDATE or INSERT time of a table?  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
From: "Juan Ramón Cortabitarte" <jcorta@tribctas.gba.gov.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


pgsql-general by date:

Previous
From: Renaud Tthonnart
Date:
Subject: Re: array containing references
Next
From: Kyle
Date:
Subject: Debug messages in beta5