Re: Problem trying to load trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem trying to load trigger
Date: 2009-08-02 17:42:32
Message-ID: 10122.1249234952@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net> writes:
> CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS $$
> BEGIN

> IF (TG_WHEN = 'BEFORE') THEN
> IF (TG_OP = 'INSERT') THEN
> NEW.createdatetime := current_timestamp
> NEW.createuser := current_user

You've forgotten to end these statements with semicolons ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis BUCHER 2009-08-02 18:40:45 Re: How to execute external script from a TRIGGER or FUNCTION ?
Previous Message Alban Hertroys 2009-08-02 17:42:06 Re: Problem trying to load trigger