That's not quite what his scheme does, his handles pre-filled future events (and historical changes thereof), not just appending new events.

Also I may be wrong but I believe your view will only ever be filled with a single row. You'd need something along the lines of:

        create view foo as
            select distinct on (id) *
              from foo_history
              order by id, date_added desc;