select updates view by default after transaction is completted