On Thu, Sep 11, 2008 at 9:10 PM, Chris Velevitch <[EMAIL PROTECTED]> wrote: > On Fri, Sep 12, 2008 at 1:53 AM, Scott Marlowe <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
