On Tue, 23 Oct 2001, Dado Feigenblatt wrote:
> Hi, I'm fairly new to this subject.
>
> How does locking work when accessing the database via web interfaces?
> Usually applications work in a browsing mode. When you click the edit
> button, the same data is presented in a form which can be submited for
> update.
There was some discussion not long ago on this list about this subject.
IIRC there was almost one solution for every poster. Maybe you can take
a look at the archives,
http://fts.postgresql.org/db/mw/msg.html?mid=1031482
> Would persistent connections fix this? Do people use this mode switching
> to implement their own locks?
No, persistent connections do not help here.
--
Alvaro Herrera (<alvherre[@]atentus.com>)
"Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)