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

From Juan Ramón Cortabitarte
Subject store procedure in pl/pgsql
Date
Msg-id 002201c0a181$f5d4f000$27012a0a@tribctas.gba.gov.ar
Whole thread Raw
In response to last UPDATE or INSERT time of a table?  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
Hello,

I'm trying to do some store procedure in pl/pgsql but the sql server says
me:

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

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.)

any help ?


pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: pg_dumpall -> fails
Next
From: Alessio Bragadini
Date:
Subject: Re: PostgreSQL packages for Debian potato