I see...
For my purposes, I'd still rather notify the user up-front that the
record is "in modify" (kind of like FileMaker does)... even though now
I understand that a row lock is not the right mechanism for that.
Is there a "best-practice" for this approach?
What about using a field to flag
Joe Lester <[EMAIL PROTECTED]> writes:
> Is there a recommended "postgres way" to determine if a certain row is
> locked... without blocking?
8.1 has a SELECT FOR UPDATE NOWAIT option. Alternatively, just do a
wait while having a very short statement_timeout.
> In my custom postgres client app
Is there a recommended "postgres way" to determine if a certain row is
locked... without blocking?
In my custom postgres client app I'd like to be able to determine if
another user is "modifying" a given record. If so, I would present a
dialog to the user such as "Record Locked. Sam Smith is a
