Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> True but what I am worried about is the data changing while I am in a
> transaction.
Start a serializable-mode transaction, and the data will not change ---
not from your perspective, anyway. Trying to lock it down to not change
from other people's perspectives seems pointless.
regards, tom lane