Re: trigger not firing

On Mon, 26 Feb 2007, joseph speigle wrote:

>
> hello novice list,
> can somebody show me where my mistake is with this trigger.
> everything is fine, but they don't fire......
>
> [postgres(at)www ~]$ pg_ctl --version
> pg_ctl (PostgreSQL) 8.1.3
> [postgres(at)www ~]$
>
> ---------------------------------------------------------------------
> drop function qp_question_moddate() cascade ;
>
> CREATE FUNCTION qp_question_moddate() RETURNS OPAQUE
> AS '
> BEGIN
>
> NEW.moddate := current_date;
> RETURN NEW;
> END;
> ' LANGUAGE 'plpgsql';
>
> create trigger qp_question_moddate_update after update on qp_question
> for each row execute procedure qp_question_moddate();

After triggers are too late for modifying NEW (since the record is already
created or changed), you'd need to make it a before trigger.