Thread: RE: [GENERAL] SET LOCK MODE ?

RE: [GENERAL] SET LOCK MODE ?

From
"Jackson, DeJuan"
Date:
> 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