As far as I understand now() returns the same time during the whole PostgreSQL transaction? But how to get real time?
Also, I am interested if there any configuration parameter to limit duration of transaction, so that after this period expiration transaction would immediately fail or somehow else prohibit following queries?