> 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