RE: [GENERAL] SET LOCK MODE ? - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] SET LOCK MODE ?
Date
Msg-id F10BB1FAF801D111829B0060971D839F3E2D0F@cpsmail
Whole thread Raw
List pgsql-general
> 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

pgsql-general by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] Optimization problem?
Next
From: "Richard Ryan"
Date:
Subject: Questions about year 2000 compliance and support