Re: Apache::Session::Store::Postgres FOR UPDATE problems

[prev] [thread] [next] [Date index for 2005/05/02]

On Fri, 2005-04-29 at 16:50 +0200, Kjetil Kjernsmo wrote:

> I guess it could be that the use we make of Apache::Session is flawed, 
> that we should call an update somewhere, but it works (apparently) with 
> the other data stores. It feels like there is something in the 
> direction of transactions but I can't figure out what... Or, if it 
> could be somebody else's bug, relieve me of the feeling of being 
> stupid... :-)

It is possible that the FOR UPDATE is spurious.  It signals to the
database system that this transaction intends to write that row.  With
PostgreSQL's MVCC transaction isolation system, it's probably not
necessary and may be causing problems.

Note that I handed the pumpkin over to Casey West several months ago.
Any issues should be forwarded thereto.

-jwb