Mike, please include to the mailing list as well, so others can help you out too. Why do you need the trigger to be FOR EACH STATEMENT? so I can understand your use case, even if it's simple stuff, please share with us your code.
Oh, so you're defining transition relations (REFERENCING NEW TABLE, OLD TABLE ) as in here?
CREATE TRIGGER paired_items_update AFTER UPDATE ON paired_items REFERENCING NEW TABLE AS newtab OLD TABLE AS oldtab FOR EACH ROW EXECUTE FUNCTION check_matching_pairs();
According to the docs, not possible to use a transition table and column list together
> I can give code when I get home, but it's pretty simple stuff
please do so, along with your trigger definition. Are you aware that you can define your update trigger to fire on a specific column?
For UPDATE events, it is possible to specify a list of columns using this syntax:
UPDATE OF column_name1 [, column_name2 ... ]
Not sure if this is possible
Basically I want to have a trigger which updates an array column in the same table when a column is updated
This works as a row level trigger, but not as per statement
I have hit the recursive issue (where update fires update trigger which fires etc)
According to the docs I cannot use columns and relative tables together
So any suggestions? I can give code when I get home, but it's pretty simple stuff
--
--
--