Re: Problems w/ PL/pgSQL not being loaded?

I just did this in 7.1 (and I think it's pretty similar in 7.0.x).

cd into the src/pl/plpgsql directory and type "gmake && gmake install"

Then as the postgres super user type "createlang plpgsql dbname"

where "dbname" is the name of the database you want to add it to.

If you add it to template1 then all new databases will automatically get
it.

good luck!

-philip

On Tue, 17 Apr 2001, Diehl, Jeffrey wrote:

> Hi all.
>
> Once again, I'm trying to climb the learning curve...
>
> I'm trying to write a trigger in PL/pgSQL to update some tables. When I try
> to load the function, I get an error message:
>
> The function is:
>
> create function update_modified () returns opauqe as '
> BEGIN
> NEW.modified := ''now()'';
> return 1;
> END;
> '
> language 'plpgsql';
>
> The error message indicates that I'm trying to us an unrecognized language.
> The recognized languages are sql, C, internal and other created languages.
> I've not loaded anything besides the default.
>
> 1. How do I load PL/pgSQL?
>
> 2. Does this function look right? It should change the a.modified field
> upon update.
>
> Thanx again,
> Mike Diehl,
> Network Monitoring Tool Devl.
> 284-3137
> jdiehl(at)sandia(dot)gov
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>