RE: [GENERAL] SET LOCK MODE ?

On Thu, 03 Sep 1998, you wrote:

Is there something like:
SET LOCK MODE {TO WAIT | TO NO WAIT | TO WAIT n}
in postgresql?
Thanks

What does it do?
-DEJ

It means if during your transaction you've found something
locked you will WAIT for it, or NO WAIT, or WAIT n seconds.
It's a standard SQL command, the main idea is to avoid
the deadlocks.

(dim)

Which standard is it in? I don't believe our current deadlock
resolution supports the syntax, but it may be possible to include it in
v6.5, so I'm sending a copy of this to the HACKERS list.
-DEJ