Re: Locking rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Locking rows
Date
Msg-id 5979.1046463010@sss.pgh.pa.us
Whole thread Raw
In response to Re: Locking rows  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Jean-Christian Imbeault <jc@mega-bucks.co.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

pgsql-general by date:

Previous
From: Ivan
Date:
Subject: Re: Few Simple Questions
Next
From: Dmitry Tkach
Date:
Subject: Re: postgres error reporting