fix view when user missing. update db for using postgres