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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
