I am trying to create a trigger on a table that simply sets the last_updated
field when any updates are made to that table.
I have tried the following: -
CREATE FUNCTION set_item_last_updated () RETURNS OPAQUE AS '
BEGIN
UPDATE item SET last_updated = now();
RETURN OLD;
END;' LANGUAGE 'plpgsql';
CREATE TRIGGER item_last_updated AFTER UPDATE ON item
FOR EACH ROW EXECUTE PROCEDURE set_item_last_updated();
When I try to execute this it hangs and postmaster eventually runs out of
memory.
Is there a way to do it just using sql not plpsql?
Why is it hanging?
Thank in advance.
Graham