Re: declare column update expression

On Thu, Sep 11, 2008 at 9:10 PM, Chris Velevitch
<chris(dot)velevitch(at)gmail(dot)com> wrote:
> On Fri, Sep 12, 2008 at 1:53 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> Here's a simple example of last modified trigger using plpgsql from way back:
>>
>> -- FUNCTION --
>>
>> CREATE FUNCTION modtime () RETURNS opaque AS '
>> BEGIN
>> new.lm :=''now'';
>> RETURN new;
>> END;
>> ' LANGUAGE 'plpgsql';
>
> This does work in 7.4. It doesn't like 'opaque', whatever that is. It
> doesn't like language plpgsql. I'm using a shared hosted database, so
> I'm probably not allowed to createlang. And it complains about 'new'.

Do you have a superuser account? Pretty sure you gotta have that to
create lang. OTOH, plpgsql is a "safe" language once installed, so
you should be able to ask your hosting provider to install it. Can't
hurt to ask.