Postgres trigger for an update

gistfile1.txt

CREATE OR REPLACE FUNCTION categorySyncLogUpdate()
  RETURNS trigger AS $$
BEGIN
  INSERT INTO shared.sync_logs(record_id,record_type,log_type) VALUES (NEW.id,1,2);
  RETURN NEW;
END;
$$ LANGUAGE 'plpgsql';
CREATE TRIGGER update_category_sync_log AFTER UPDATE ON jobs.categories FOR EACH ROW
EXECUTE PROCEDURE categorySyncLogUpdate();