Обсуждение: Re: [SQL] Updating selected record

Hi Levi,

On Feb 9, 2005, at 4:01 AM, Levente Lajko wrote:

> Yes, I have found this statement. However, it doesn't prevent others
> to see that specific row in its state before the update. The point is
> to lock the row for reading as well.
> Unfortunately, the postgres doc clearly states that row-level locks
> allow others to query the row.
> The only solution is something like process handling which is not a
> headache at all, only I am surprised a bit not having this option in
> pg.
>
> Any comment would be welcome.


Ok, sorry I did not completely understand your question. Perhaps you
could write a function or rule that automatically filters out the rows
that are being updated.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL