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

Yup.

Took me all of 15 minutes to do this and test it.  

Thanx much,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl@sandia.gov


> -----Original Message-----
> From: Philip Hallstrom [mailto:philip@adhesivemedia.com]
> Sent: April 17, 2001 5:02 PM
> To: Diehl, Jeffrey
> Cc: pgsql-sql@postgresql.org
> Subject: 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@sandia.gov
> >
> >
> > ---------------------------(end of 
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to 
> majordomo@postgresql.org)
> >
> 
>