| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | "Levente Lajko" <levente(dot)lajko(at)topline(dot)co(dot)uk> |
| Cc: | Postgresql-General General' <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] Updating selected record |
| Date: | 2005-02-09 13:56:04 |
| Message-ID: | 57136318-7AA2-11D9-8527-000A95B03262@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2005-02-09 14:03:23 | Re: indexing just a part of a string |
| Previous Message | John DeSoi | 2005-02-09 13:34:52 | Re: Postgresql and Macintosh |