Re: PLPGSQL - FUNCTION CREATION

Please do not reply to this posting - I was too hasty in my post - I have
since found the answer:

$ createlang plpgsql <dbname>

Doh!

PS: Always search the archives thoroughly...Doh!

"Andy Hallam" <ahm(at)exel(dot)co(dot)uk> wrote in message
news:9p1egi$hsb$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> Hi all.
>
> I'm trying to write a function to update a TIMESTAMP column.
>
> MY TABLE SCHEMA:
>
> CREATE TABLE UserLog
> (
> User NCHAR(20) NOT NULL,
> ModifiedTimeStamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
> )
>
> What I want to do is that when a record is updated the ModifiedTimeStamp
> column is updated to the current time.
>
> Looking through the docs - great - create a function to do this - great -
> Ohh no!
>
> MY FUNCTION:
>
> CREATE FUNCTION NewTimeStamp () RETURNS OPAQUE AS '
> BEGIN
> NEW.ModifiedTimeStamp := ''now'';
> RETURN NEW;
> END;
> ' LANGUAGE 'plpgsql';
>
> When I execute the CREATE FUNCTION statement I get the following error:
>
> Error: Error while executing the query;
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
> Recognized languages are sql, C, internal, and created procedural
languages.
> (State:S1000, Native Code: 7)
>
>
> Help!
>
>