It happens when another transaction commits a change between your two reads. PostgreSQL allows it at READ COMMITTED and prevents it at REPEATABLE READ.
Non-repeatable read
Reading the same row twice in one transaction and getting different values.
It happens when another transaction commits a change between your two reads. PostgreSQL allows it at READ COMMITTED and prevents it at REPEATABLE READ.