Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem trying to load trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem trying to load trigger
Date
Msg-id 10122.1249234952@sss.pgh.pa.us
Whole thread Raw
In response to Problem trying to load trigger  (Michael Gould <mgould@intermodalsoftwaresolutions.net>)
Responses Re: Problem trying to load trigger
List pgsql-general
Tree view 
Michael Gould <mgould@intermodalsoftwaresolutions.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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Problem trying to load trigger
Next
From: Denis BUCHER
Date:
Subject: Re: How to execute external script from a TRIGGER or FUNCTION ?