create trigger hangs
Cannot be done with PG 8.4.
It's actually on the TODO of postgres to reduce trigger requirements: 


https://wiki.postgresql.org/wiki/Todo
http://www.postgresql.org/message-id/1213387611.25121.250.camel@ebony.site