| From: | "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com> | 
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> | 
| Subject: | Column Specific Update Trigger Routine | 
| Date: | 2010-05-06 20:12:32 | 
| Message-ID: | BD69807DAE0CE44CA00A8338D0FDD08302D2654129@oma00cexmbx03.corp.westworlds.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
I am trying to create a update trigger on a table that basically will only fire when a specific column is updated. I am using version 8.4.3.
My plan of attack was to always fire on any row update, and pass in the OLD and NEW column that I want to check.
CREATE TRIGGER check_lockout
    AFTER UPDATE ON acct_table
    FOR EACH ROW
    EXECUTE PROCEDURE acct_unlock(OLD.userid,OLD.ownerid,OLD.password,NEW.password);
This fails with :
[postgres(at)linux1505 ~]$ cat check_lockout_trig.sql | psql testdb
ERROR:  syntax error at or near "OLD"
LINE 4:     EXECUTE PROCEDURE acct_unlock(OLD.userid,OLD.ownerid,OLD.password,NEW.password);
What am I doing wrong? Or is there a better way to go about this?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Plugge, Joe R. | 2010-05-06 20:51:37 | Re: Column Specific Update Trigger Routine | 
| Previous Message | Leif Biberg Kristensen | 2010-05-06 15:37:52 | Re: Need a help in regexp |