"D. Dante Lorenso" <[EMAIL PROTECTED]> writes:
> Douglas McNaught wrote:
>> How quickly after you update the row status are you comitting (and
>> releasing locks)?
> I am calling a stored proc from PHP. Since I do not begin a
> transaction, I assume that my call is automatically committed
> immediately after invocation.
Have you actually verified that, or are you just assuming it?
I believe that PHP has some sort of autocommit on/off option,
which might possibly be doing things behind your back.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings