Re: Question on locking

From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Question on locking
Date: 2004-11-05 13:26:41
Message-ID: a06110408bdb12fcf4347@[192.168.0.116]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Retraction of the previous (I realize SELECT FOR UPDATE can be useful
with Tom's method)

>Note: after thinking a little about it there's no need to use SELECT
>FOR UPDATE with Tom's method. A regular UPDATE will do (it does its
>own locking all by itself for only the time needed).
>
>(Therefore, if Tom's method would be the only recommendable one, the
>command SELECT FOR UPDATE would be without purpose. From this again
>I deduce that it originally must have been meant for use in long
>lasting transactions.)

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2004-11-05 13:28:42 Re: Install 7.4.6 on Redhat 8.0 - Any issues?
Previous Message M. Bastin 2004-11-05 13:13:12 Re: Question on locking