This doesn't work:
create table event ( ... time int default date_part('epoch', timestamp 'now'), ... );
I'm no postgresql expert but shouldn't this one work
time int default date_part('epoch', now())