Re: declare column update expression

On Thu, Sep 11, 2008 at 9:10 PM, Chris Velevitch
<chris.velevitch@gmail.com> wrote:
> On Fri, Sep 12, 2008 at 1:53 AM, Scott Marlowe <scott.marlowe@gmail.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.